New Help to Open Subform to a specific record
Posted on 2011-03-10
I have a form named NewProspect which is a MainForm.
It has a subform named NewQuote.
The two are connected by the CustomerNumber field, which is type LONG
If I open the subform properties I see:
The Recordsource of the NewQuote form is a tale name Quotes
I need code that I can place in an event procedure located on another form that will open the NewProspect form to a specific CustomerNumber (for example, 530018) and the NewQuote form to a specific quote that matches a QuoteNumber (for example, 12543) that I will input with code.
As each customer may have a number of quotes, it would be ideal if the form opens with all the quotes that match the specified customernumber selected, and the user can cycle through all the quotes (for this customer) using the navigation buttons on the NewQuotes form---- however, the form must open with the specified quote selected.
Is this posible?