Move from form to form with same record

[soulice]

Have a db with 10 forms. Regardless of which form is opened..a user will search for a record to modify. If they move to another form I need to keep that record id alive so the next form is automatically on that record. Thoughts?


I was going to do a little macro that would fire on each form open and check a VBA snippet for a record id. If not null, load said record, else load first record.

[JenEveAle]

Are they opening the forms in the same order each time? For example, are they moving from FormA to FormB sequentially every time? Or might they be opening the forms in random order?

[soulice]

Can be random. I would have had a main form with button to go the other forms, but I did not build, came in later.

[JenEveAle]

If you put buttons on the forms that they will use to open subsequent forms, you can add a filter on the second form that pulls in the ID from the first form. However, they would have to always start with the same form and they would only be able to move between forms via the buttons. This may pose too many limitations on what you're trying to do, though.

[orange]

In your first post

If they move to another form

-- exactly how does the user do this?

Is there some logic that controls when/how a user opens a form? Some process steps or something?

[soulice]

@orange - sorry about that. They have 10 tabs that they can click on to get to any other form. It appears they may be on a master form, so to speak.

[orange]

So how would you know which form should be opened with a filter or OpenArgs?
Can you set up the logic to do that? If so, then you could do the associated programming to make it happen.

[soulice]

That is the dilemma. I think I will put each tab/form to fire some VBA. Let VBA tie the recordid to the form....or somehting like that.

[orange]

What do the users say? Are they complaining?
I think you need some sort of process map that shows
for each form, what buttons can be clicked and what should happen.

You need some sort of plan that is relevant to the situation.
I'd have the users involved and agreeing on what should happen when and work form that.

[soulice]

would love to, but...users designed via a helper. Helper emailed to me and said make it do this... LOL

[orange]

Good luck.

[BRV]

Could you use a public DAO.Recordset variable and use the forms .GotFocus property to set the forms recordset property to this variable?

Then maybe use the .LostFocus to force the forms now current recordset back to the variable so that when you switch forms, it will pass the then current record.

[funi.t]

hi i have a similar problem.
I have a Main form with buttons that open 6 other and a few fields for searching data .I would like the buttons to Search for the data that is provided by the user in the Main form and open the forms at the same time.please help

[JenEveAle]

Are you saying you want ALL 6 forms to open everytime? Or, would various forms open depending on what what selected in the search buttons?

[funi.t]

hi.i would like the forms to open depending on the data selected on the main form