Moving to new record from a different form

[liam_898]

Hey guys,



I've got two forms. Form A which displays 'Customer purchases' and form B that allows the user to add customer details quickly (a sub form)

The issue I have is that I need requery form A upon closing from B to show the data added. This results in form A moving to record 1 rather than a new record that was previously selected.

Any suggestions guys?

Only thing I can think of is setting the onload of form A to:

DoCmd.GoToRecord , , acNewRec

But from the users perspective I don't particularly want that

[RuralGuy]

Maybe this link will be helpful: http://www.baldyweb.com/Requery.htm

[liam_898]

Maybe this link will be helpful: http://www.baldyweb.com/Requery.htm

Hmm, could work, but a new record would show as null.

[RuralGuy]

I thought you said a New Record was previously selected?

[liam_898]

I thought you said a New Record was previously selected?

Well yes, add new record is open but with the above example it can't reference a new record as it has no ID :/

[RuralGuy]

So you need to tell FormA what the NewRecord ID is, right?

[liam_898]

So you need to tell FormA what the NewRecord ID is, right?

Well it has no ID. From A and B are separate tables.

Suppose I could save the ID when opening form B, which I think is what you're getting at.

Cheers

[RuralGuy]

I guess I do not understand your db structure. What tables are involved in FormA and what in FormB. What record do you have selected in FormA before opening FormB.

[liam_898]

But again that wouldn't be ideal as there are required fields that would need to be changed

[liam_898]

Okay, here are some print screens. its tbl_Customers, tbl_Customer_purchases and tbl_Products that are being used.


Table structure



This is the form in question (Form A).. Customer field references customer ID, product field references product ID.


This is form B..


However when I click save and close it goes back to record one, which is not what I want :P

Code that is used to refresh is:

Public Sub Command17_Click()
    
    Call frm_Customer_sub_SaveRec
    Forms!frm_Customer_purchase.Requery
    Call frm_Customer_sub_CloseSubfrm
    
End Sub

[RuralGuy]

Are you aware of the fact that the NotInList event of a ComboBox will allow you to add a New Customer and select that customer after you have created them?

[liam_898]

Are you aware of the fact that the NotInList event of a ComboBox will allow you to add a New Customer and select that customer after you have created them?

Yes, but that combo box is displaying the customers first and last name. So to do it that way I'd need to add the ID and the first and last name aswell from one combo box.. and I'm pretty sure that cannot be done.

It's not what I wanted, but I've come up with a quick work around. I'll just reopen the form A when from B is closed and ensure From A opens on a new record with the 'acAdd' command.

I just thought there would be a quick way to make one form go to a new record from a different from event. (I'm relatively new to VBA so just thought I'd ask).

Appreciate your time ruralguy

[RuralGuy]

Glad to hear you got it sorted. I marked this thread as Solved for you.