Calling Actions on Navigation Page SubForms

JpSkyPilot

Registered User.
Local time
Today, 06:18
Joined
Feb 23, 2012
Messages
20
Hi..

Having all sorts of problems getting used to referencing forms when using the Navigation Form

I have three forms:
Navigation form -- "Navigation Form"
Main Form --- "Vehicle Main" with a subform control
SubForm --- "subVeh" as a continuous form

I assign the recordset to the subform (subVeh) from the "Vehicle Main" form (using VB) and call the recordset for the subVeh to be "SubDatRst"

On the main form, I want to put a search string for the last five numbers in the VIN of the vehicle. When the operator enters the five characters and leaves the text box, I want the appropriate vehicle (based on the VIN) to be highlighted in the subForm (subVeh).

So, there's a text box on "Vehicle Main" called "txtFindVeh" and when the person completes the five numbers and the box loses focus, the following procedure is called:

Set rs = SubDatRst.Clone

rs.FindFirst "Right(VIN,5) = " & Chr(34) & Me.txtFindVeh.Text & Chr$(34)
If Not rs.EOF Then [Forms]!subVeh.Form.Bookmark = rs.Bookmark

I have tried all sorts of combinations to address the subVeh form, but cannot get it.

First...how can this be done? How do I properly address it? Second...is there someplace that gives a fairly plain explanation of how to address subforms such as this? (I was calling a procedure on a Navigation Form's subform from a module and the format was crazy...played with it and finally got it, but took hours...any suggestions?...besides going to school :))...

thanks
 

Users who are viewing this thread

Back
Top Bottom