I have a CONTINUOUS form that shows all record in a table. I would like it to be very obvious to a user which record they are sitting on so they can press a button and open a different form to edit that record. Any help would be greatly appreciated.
Yes, when someone enters the Vendor & product in the local table I want the department to automatically update the department field and store the data in the local record. All records are in the ODBC db (and in some instances there are multiple products with different vendors so I need to meet...
Need more help
I am still having problems.....here is my setup
ODBC table
Vendor (key)
Product (key)
Department
Local Table
Rec # (key)
Vendor (added)
Product (added)
Department (I want this field to automatically populate (and be stored) from ODBC table based on what is keyed into the added...
I have a form that I would like to have some fields filled (product & vendor) in manually and a corresponding department populate (from linked ODBC table) automatically. How do I go about getting this field looked up without creating a drop down box?