Back to original form

[hawzmolly]

I have a form (myform1) that takes data from an unbound comb box. I need to make an addition to the table from which the unbound combo box draws it's info and then be able to reopen the combo box to enter the new data.

I have a Command Button that takes me to the data entry form (myform2) to update the combo box table.

On the second form (myform2), after data entry, I have a Command Button that runs the following Macro:

Macro
Step 1 - Action = Close, Object type = Form, Object name = [my form2], Save = Yes

Step 2 - Action = Close, Object type = [my form1], Save = No

Step 3 - Form Name = myform1, View = Form, Filter is blank, Where Condition is blank, Data Mode = Add, Window Mode = Normal

When I click of the Close button the system completes all the steps. However, I was expecting the return to my original form (myform1) in the same condition as when I left it but, I find that the data has been saved in both my original table as well as my revised table and a new blank original form (myform1) is happily waiting for me to add new stuff.



What I need to do is get back to the original form in the same configuration as when I left it. Then I can continue to complete the form.

I really thought I could do this using the macro. Please show me the error of my ways

Thanx in advance.

[Icewolf0927]

Try not closing the first form. I am thinking if you leave it open it should keep the information there.

[weekend00]

Addition to ICEWOLF's suggestion,
don't close form1, but add form1.requery to refresh the showing data.

[hawzmolly]

ICE

If I simply close [myform2] the new data does save to the table and I get a return to [myform1] which is where I did leave off. However, now I need to fill in the data on [myform1]. The problem is unless I close [myform1] the new data just added does not show up on the unbound combo box. Therefore, the new info can't be added to the table for which [myform1] is being used.

What I need to do is reset the current [myform1] such that the combo box will be up to date as well as keeping the data already entered.

I also tried the requery but that didn't work either.

Another piece of info that may help. If the [myform1] is closed then entering the ID number returns a different form that is essentially an edit form. I do not want my operators to have to start over and then be taken to the edit form. There should be a way to just continue where the operator leaves off i.e., back to the original form.

??? Any more suggestions or any code i.e., "On Click" that might work instead of a macro.

[hawzmolly]

I was able to solve the problem with your suggestions. Did it using code.

Thanx all.