Opening Form to a record with same ID value in field. (FIND on open)

[relliott]

Ok, so here it goes, my first post.



I am a newbie to the forum and Access but have plugging my way through. I have been creating pretty complex forms (IMO) and need some help with Opening a new form from the Main form that is linked to the ID.

So the Main form consists of CustomerID and then a Subform with the Name then another subform with more information. In order to add more Customer names, I have a Create New Party button. In addition I have a create new document button in order to add type of reciept, date, and that sort of thing.

My question is that when I click on the New Document button, how can I link it to the specifac record(The New document form has the customer ID at the top as it is filled in when a New Customer Record(CustomerID) is created from the main form. ). My friend said something about passing a variable to a stored procedure(I am using sql server. ) but I believe it is easier then that.

The record in the New Document folder is already created, I just need to know, essentially how to(Find) the record when the New Document Form opens.

I hope I was'nt too confusing. thanks for the help in advance. I hope to get to know the forums better in the coming weeks.


-Ryan

[relliott]

After even more research I found the answer. For anyone wondering this is my source. It all worked after I manipulated some of the code. It gave me the right idea though. I knew I was getting my filter code wrong!

http://www.access-programmers.co.uk/...ad.php?t=80660

[RuralGuy]

So you have the information you need and this thread is ready for you to use the Solved thread tool right?

[relliott]

Right.. do I have to do that or is that I moderator function? Sorry.. I don't see it anywhere.

[RuralGuy]

The link in my signature shows you how to do it and it is not limited to Mods.