Combo Box Issue (A 2003)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

No problem!

Reply | Quote

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):
[indent]

---

Me.trailerSchedule_Subform.form.Map_Coord.Requery

---

[/indent]

Reply | Quote