Search results
-
M
Form with combo box, where chosen value causes the rest of the form to populate
SELECT DISTINCTROW tbl_OffsiteCDs.CDID, tbl_OffsiteCDs.JobNumber FROM tbl_OffsiteCDs ORDER BY tbl_OffsiteCDs.JobNumber; is the code I'm using for the query from the combo box JobNumber. But choosing a JobNumber in the combo box is NOT updating the other fields on the form. What's wrong? -
M
Form with combo box, where chosen value causes the rest of the form to populate
I have a table that contains these fields: ID, JobNumber, Title, Date. I want to make a combo box for JobNumber so that I can choose a value for JobNumber, and have the other fields on the form autopopulate with information from the table. I'm sure this is really obvious and I'm just missing it. -
M
Should I use a combo box?
Excellent! It works like a charm! Thanks for your help. Now I definitely need to hit the books and learn SQL. -Emily -
M
Should I use a combo box?
Forgive me if this is a dumb question... I'm pretty new at using Access. Am I correct in thinking I should enter your above suggestion in the SQL view of the RowSource property of the combo box? The thing that currently reads like this: SELECT tbl_Contacts.ContactID, tbl_Contacts.FirstName... -
M
Should I use a combo box?
I am building a form that combines data from several tables. One table, Jobs, contains information about projects (like job #, budget, and so forth). That table is linked to another table, Contacts, that contains information about individual clients, via the ContactID #. I want to be able to...