Update on Sync Combo Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, got the second problem of the categories list only displaying the first item in the list regardless of what was clicked on within the list to work properly.....just required "rearranging" the select query :-

However, now once I move to the second line (record) within the subform the category that was choosen for the first line doesn't display anymore, nor does it display on any of the records - any clue why? The control source is set to categoryid, and it is updating the table correctly, it just doesn't show up on the form. big arrrg

Still have the stupid prompt box appearing too.
 
Cathi

This will help you understand a bit more why the data disappears. Let me
know if you have any questions.

Data in a combo box control on a continuous form/datasheet disappears
http://www.fmsinc.com/free/tips.html#tip16foraccess

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Cathi said:
Ok, got the second problem of the categories list only displaying the
Click to expand...
first item in the list regardless of what was clicked on within the list to
work properly.....just required "rearranging" the select query :-)
However, now once I move to the second line (record) within the subform
Click to expand...
the category that was choosen for the first line doesn't display anymore,
nor does it display on any of the records - any clue why? The control
source is set to categoryid, and it is updating the table correctly, it just
doesn't show up on the form. big arrrgh
 
Back
Top