Help w/Combo Box posting to two fields 1

[rokkit99]

Hi All,

I have one little problem with an access form. It's the Haul Table Entry form. The 2nd entry down is a combo box. It show the Client Number and Client Name in the box, and then posts the Client Name in the Client Name field in the form. The Combo Box is Called Combo 23.

I also need the Client Number to Post in the Client Number Field. It is not currently on the form, but is one of the fields in the table. When the other forms & reports try to get the client number from this haul table, they are getting a blank return because this client number ends up being posted in a field called Combo Box 23.

Any way to post that Combo box entry to the Client Number field? Any help or fix would be greatly appreciated as they as trying to use the program and this is the final bug.

Thanks - Jim

 

[LittleSmudge]

It sounds like you just simply need to change the Control Source of ComboBox23 to ClientNumber.




By-the-way
It .. .. posts the Client Name in the Client Name field in the form.
No it does not !

It .. .. posts the Client Name in the Client Name CONTROL on the form ( which is BOUND to the ClientName FIELD in the underlying table ).
Forms have CONTROLS
It is Tables that have FIELDS



'ope-that-'elps.

G LS