Synchronized Combo box did not update record

  • Thread starter Thread starter Ed Dror
  • Start date Start date
E

Ed Dror

Hi there,

I have a form base on table with two combo boxes
Which I synchcronized them base on Article ID 289670
Until here everything works fine

Base on the synchronized combo box I have a text box
with the Source code pointed to the synchronized combo box (ObjectName =
myCBO)
Text box Control source: =[myCBO].Column(3)

Now the text box pupolated on the form but when I save it
I'm not getting an error message but the record not saved to the table

How do I fix it?

Thanks,
Ed Dror
 
Hi there,

I have a form base on table with two combo boxes
Which I synchcronized them base on Article ID 289670
Until here everything works fine

Base on the synchronized combo box I have a text box
with the Source code pointed to the synchronized combo box (ObjectName =
myCBO)
Text box Control source: =[myCBO].Column(3)

Now the text box pupolated on the form but when I save it
I'm not getting an error message but the record not saved to the table
Click to expand...

Are you trying to save the data in the textbox into the table? You
probably should NOT be doing so, and you certainly cannot do so in
this way: if the control source refers to an expression (as above)
then it does not refer to a table field.

The textbox does not appear to have any relationship to synchronizing
two combo boxes, so I'm not sure I understand the context!

John W. Vinson[MVP]
 
Back
Top