Go to selected record

[Vadran]

Hey guys, new to the forum and fairly new to access as well (no formal training whatsoever).

So I'm making a database and need help.

So far I have a Table that has data, and I run it through a query to filter, and end user will see a form with add/edit buttons. To add data I have user fill out a popup form with drop down boxes and that works fine, but I want the same thing for an edit tab. When I use the button the edit form, it always defaults to the first item in the list, rather than the one that's selected on the previous form.

How would I mouse select table data, open the edit form, and have it open the selected line item?

[June7]

Review http://www.allenbrowne.com/ser-62.html

[Vadran]

Data is already filtered. I was able to do a query for that.


Let's say I selected item ID 42.




But when I hit edit, it opens the first line item on this query list. Right now its a simple "open form" command but I don't know how to have it go to the item that's selected.

[June7]

Are you showing tables/queries or forms on each of those tabs?

Post your code for analysis.

[Vadran]

Each tab will be a different table query.


So far all I was able to figure out is how to do an embedded macro for the "Edit" button. My VBA skills are practically non existent but figured this is a good excuse to learn.

[June7]

What you show is a macro, not VBA.

Need criteria in the WHERE CONDITION argument. I've never tried this with a table/query as the SourceObject for a subform container. Not sure can be done. Try:

[Record ID]=[subform container name here]![Record ID]


Should avoid spaces and special characters/punctuation (underscore is exception) in naming convention.

[Vadran]

hmm. no dice. Would it be possible with VBA?

[June7]

What happened?

I just did a test with macro and table as SourceObject. It does work. Just have to get the criteria expression correct.

[Record ID]=Forms!formname!subformcontainername![Record ID]

[Vadran]

Ok. So I dragged and dropped the query its self onto the tab and it didn't seem to care for that. I created a subform and that made it work. Still have to type it though so I need to play with it and see if I can figure it out.

[Vadran]

wait figured it out. Awesome. Thanks for your help good sir!