Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo Box Issue (A 2003)

    Good Morning All,

    Attached is a sample db with a Main form, frmTrailer, and a subform, frmSpeedTrailerRequests. On the subform is combobox that lists a set of map coordinates that designate where a particular speed trailer can be placed. This works okay for Speed Trailer # 1, but when I bring up another speed trailer, the same coordinates appear. I can't seem to get the speed trailers and coordinates in sync. tblTrailerLocation has a list of all trailers and possible coordinates. As usual, any and all assistance is greatly appreciated. TIA.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combo Box Issue (A 2003)

    The Map coord field in tblSpeedTrailerRequests should be a number field instead of a text field, and it should be linked to the primary key in tblTrailerLocations. This also requires changing the setup of the combo box bound to Map coord.
    See the attached version.
    Attached Files Attached Files

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Combo Box Issue (A 2003)

    You need to force the combobox to requery any time the "Trailer No" on the mainform is changed. This would be when you display a record (use the OnCurrent event) or add a new Trailer. Code would be (I needed to replace the spaces in your control names with an underscore to get it to show correctly):
    <hr>Me.trailerSchedule_Subform.form.Map_Coord.Requ ery <hr>
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box Issue (A 2003)

    Thank you Mark and Hans for your replies. Unfortunately, Hans, the map coordinates need to be text fields, to match the grids on our city/county maps. The requery idea seems to work. Thanks again.

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box Issue (A 2003)

    I need to apologize to you Hans. I understand now what you did. I can show the real grid "text" in a query or report.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combo Box Issue (A 2003)

    No problem!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •