Go to a record selected in a listbox

[LMBradbury]

Hi,
I want a list box within the data entry form that lists the records. When the user selects the record, I'd like the form to pull that record up. I have tried several ways and now don't know which way is up.

Thanks for any help!

 

[LMBradbury]

I figured it out!

 

[LMBradbury]

I figured it out!

Just kidding no I didn't. I found a source to tell me to that my form isn't linked to a query causing the issue to not be able to select "Find a record based on the value I've selected" I converted my Select statement into a query and it broke.

 

[LMBradbury]

Just kidding no I didn't. I found a source to tell me to that my form isn't linked to a query causing the issue to not be able to select "Find a record based on the value I've selected" I converted my Select statement into a query and it broke.

 

[Micron]

It doesn't make a whole lot of sense to me to list records in a listbox when you could just show the records or, use controls to limit the returned records by filtering the form. Yes, your form would have to be bound to a table or query in order to go to a record on it.
Is approvalID a meaningful value for the record choice or is it just date and/or buyer? Maybe a textbox where user could input a date, and a combo that lists the buyers (both on the form header) would be a better means of filtering the records.

 

[LMBradbury]

Hi, thank you for the input! I am just not as fluent, so I wouldn't even know where to begin with a the text box entry. I also have some even less computer savvy folks using this, and would like it to be in plain site. It also is a means to show status of the record if it was signed or not. I hope that makes more sense.

 

[welshgasman]

Microsoft Access tips: Search criteria

Free sample database for Microsoft Access 2000 and later, demonstrating how to build criteria from many optional entries, and handle different field types, exact matches, partial matches, and ranges.

allenbrowne.com