Forum Home
Press F1
Thread ID: 18622	2002-04-29 01:34:00	MS Access	Guest (0)	Press F1

Post ID	Timestamp	Content	User
46221	2002-04-29 01:34:00	I have been trying to get an access form to work with a query. I am a newbie to queries What I am trying to do is type in a code number eg. 12.123 and that to go to a table a get the rest of the info from the next two Columns in the next feilds on the form. Thanks David	Guest (0)
46222	2002-04-29 04:19:00	Your simplest way to get started is to add a 'combo box' to your form. (This will contain all the valid numbers that will match records in your table). Use the Wizard to help - it will write the code for you. Select 'Find a record on my Form based on the value I selected in my combo box' when the wizard asks how the combo will get its values. Then follow the instructions to complete. (Your form must have been based on the table you are looking up the data from) - that is the 'Record Source' for the form must be the table. Good Luck	Guest (0)
1