Search results

Ok, here is the reason that I think I need to somehow change this. Everything works great, but in “tblstudents”, it shows the “gradeid” for the grade and not the grade itself. This is fine but I have to keep track of these values, but the VBA script that I am using to keep track of any changes...

Ansentry, thanks for your reply. It works and does the job, but it is not what I am looking for. I need to keep the same structure as I put in my example. There is alot going on on this form, and I need it to update the field in this manner. I hope somebody can help me. Thanks...

Please help, how do I make this drop down fill in the information in the grade field?

You are awsome many thanks.

Hopefully this will make more sense. I want add a search field into my form. When I input data into this search field, I want it to search for the ID number, then I want it to populate my form. I will be inputting data into the search field with a barcode scanner and I will hit enter after I...

I have this sample database. I would like it to auto update the bananas field and the apples field when I type data into the ID field and press enter. Can somebody please help me. Thanks.