One of the forms I created in Access needs to do the following:
I click on the button
this opens a box
I enter the po #
this brings up the form
the form is populated with the records matching that po #
Yes, all my tables, queries, macros and other forms are functioning perfectly.
this one form "debit memo form" only populates with the first record in the query
so I enter po# 14845 which is debit memo #8124
instead it brings up po# 59624 debit memo # 8121
When the form opens, and shows the 8121, if I hit the scroll button on the mouse, it will show all of the records in sequential order.
How do I get this to populate with that specific record? When I created this I made it open the query as well as the form so that I could see if it was bringing up the correct record from the query. It is.... the the query seems to be fine. I've tried so many variations on the form.
So even though the form seems to be the culprit, could it actually be the formula in the query?
I hope I explained this clearly enough.