MS Access Form/Table Problems and Suggestions

[djmc]

Hi I have two questions.

1. I have a form for data entrying of records.
I want the user to be able to just type in the dealer number and the text box for dealer name will show the name for that particular dealer number so the user doesn't have to enter it in themselves for faster data entrying. I have a second table which is just a list of dealer numbers with their names and a primary table for my main data. How will I get this functionality to work? I tried doing a DLookup() bound for that dealer name text box but i get an error, maybe i am doing it wrong? Any suggestions?

2. Secondary I find that when i have BOTH the form and the table of data open. If I use the form to add a record entry, the table which was opened before doesnt show to update unless I close the table and reopen it. Same goes with the case if i add the record from the table, the form doesnt update with the added record in the list.

Please give me some suggestions on these questions. Thanks.

 

[ToeShot]

1) Create a form and just put the employee number on it. I usually use a ComboBox, this will initiate the combobox wizard. Select the first option 'Use column from a table or query'. Follow the wizard the rest of the way through. On that same form add a subform with the rest of the information e.i. Employee Name. when the wizard ask to select a link for master child fields select the employee number. this will give you the result that you are looking for just by typing in the empployee number.

hth Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait