Navigation - refreshing data from one button to another

[sd1961]

I'm just working with a small sample I built before I put this into place in my live database. Here is my problem. I have a Navigation form with two navbuttons (Part1 and Part2). Part1 form has a combo box the looks up a record and displays the results in the text boxes. If I click on the Part2 navbutton and come back to Part1 my original look up has been cleared.

I realize that because the way Navigation forms load and unload the forms this is the nature of the beast. When a user selects the the combo box on Part1 I store that ID number in a tempvars variable.

What I am trying to do is when I go back to Part1, have the tempvars variable set the ID number in the combo box and then refresh / reload / repaint the data. For the life of me I have tried everything. I tried putting code in the OnLoad, OnActivate and several other places with no luck.

Can someone show me how to do this. I figured I could do something like this:

me.comboPart=tempvars("LastPartViewed")
me.comboPart.Requery

When I go back to the Part1 navbutton, the combobox will display the correct item but the rest of the fields have not refreshed and show the first record data from the table.

I know I'm doing something wrong but don't know what.

Thanks

[twinnyfo]

I am madly confused....

If Part1 has a record open, what is happening with Part2 that is navigating to another record? A form does not move to a another (or a blank) record magically. You must be telling it to go somewhere....

If it is as simple as when you are on part 1 that updating the combo box will bring up the record you desire, then simply re-execute that code when you assign the correct value to the combo box:

Me.ComboPart_AfterUpdate

This assumes that you have code assigned to that event.....

[sd1961]

In my test database I only have the two navigation buttons. Right now Part2 doesn't even have a form to it. My working database does but I'm using this db as a test bed.

The Part1 navigation form has comboPart that looks up a recipie name and then shows data about it. So for example I pull up Chocolate Pie and it displays everything. If I click on Part2 and go back to Part1 (by default) everything is cleared. I have to re-select the Chocolate Pie.

The comboPart_AfterUpdate already has the default code to look up the record so that works when I select a new record but I want it to pull the record back up when I move to Part2 and back to Part1 navigation button. Like I said, Access closes Part1 and opens Part2 when it is clicked and then closes Part2 and opens Part1 when I come back thus the previous on screen record is cleared on Part1

I've tried using the OnLoad event to do it and I can assign the ID I want to the comboPart but when I try requerying it I just get the recipie name and the underlying record doesn't seem to refresh.

Does that make sense? If I could attach a sample I would show you but I don't think this forum has that ability.

Thanks
David

[twinnyfo]

When you runt he code to go back to part1, then do as you have already suggested:

me.comboPart=tempvars("LastPartViewed")

But then, add my suggestion. This will requery the form to pull up your desired record.

[sd1961]

Ok I tried that too before and just now to make sure. I get an error "The expression you entered requires the control to be in the active window". This is after being called from the OnLoad event of the Part1 navigation form.

It is almost like it's not loaded. When it breaks at the error you can see the Navigation form is there but the Part1 and Part2 forms are not shown until click OK to acknowledge the error.

I noticed I can attach a file. I'll get a database zipped up in a bit so you can see what I'm talking about. I know Navigation forms are not like subforms but I would still think this is possible OR I'm doing something wrong.

[twinnyfo]

How about opening Part1 from Part2 and applying a filter. This is buildin the DoCmd.Open acForm properties. Very simple to use.

[sd1961]

Ok I have attached a sample database with 4 little parts. I set the now combo0 to ID 4 when it loads and I commented out the line combo0_AfterUpdate so you won't get the error right off the bat.

So you will see going from Part1 to Part2 the combo box displays part ID 4 correctly but the underlying record is not refreshed.

If you activate the combo0_AfterUpdate line you will get the error I am getting saying the control is not in an active window.

Maybe someone will have the answer.

[twinnyfo]

Looking at your DB gave me no clue whatsoever as to what you are trying to do.... Not trying to be a jerk, or anything, I'm just confused. Unless you are publishing this to sharepoint or something like that, there is no need for a Nav Form. Just use a tab control and all your values stay in tact.

[sd1961]

Thanks. I might have to do that. Just thought this was the way to go for my application but no harm in changing it. Just would like to know if what I'm trying to do is even possible.

Thanks again for all your help.

[twinnyfo]

Because I'm not sure what you are trying to do, I can't give you a reasonable answer.

If what you are trying to do is pull up a record under one tab, then go to another tabl and do something else, then go back to the first tab and continue with what you were doing, then, yes, you can--using a tab control.