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
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