Hi,
I posted this question before but was unable to follow up on the reply, then I think the thread went stale.
I have a form for looking at student records which loads from a query after selecting student "status" (e.g. active, inactive, on leave, Graduate, etc.). This form is used by multiple new users and the cells are open for editing and adding new records. When we use the search function by making the LASTNAME cell active, sometimes it gets over written by the search entry.
Is there a way to either make this field directly searchable ...or...can I create a combo box to display all students returned from the query (e.g. active) and be able to select a student and have the record for that student to appear or load?
I'll try to attach a DB but I have been having trouble. I am alo not good with SQL so I tend to do everything from a query builder
Thanks and take care,
Daryl