Environment versions
Network:
Windows 2008 Server
>I am creating a data entry screen for a event planning client to enter their Vendor data and the point of contacts for those vendors.
>
>The basic table layout is vendor.dbf, vendor_cat (vendory category i.e. photographer, wedding cake baker etc).
>
>1. How do I setup the combo box to populate the choices from the vendor_cat table? I can add a record but when I goto the next Vendor record, the last vendor category I selected still appears. If there is anoher vendor record, then that particular vendor category should appear or if they did not select a vendor category, it should goto the top of the table and allow them to make a selection.
If I understand you correctly, the RecordSource of the combo is vendor_cat and you want to synch it with the current record in Vendor.
So, set the ControlSource for the combo to the appropriate field in Vendor, and refresh the combo when the record pointer moves.
If that's not what you meant, please explain some more.
Tamar
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only