getting data from one form to lookup a record on another form

  • Thread starter Thread starter Greg C
  • Start date Start date
G

Greg C

Morning All,

Here's what i need to do. I have a Form
StandardQuoteJobNum based on the tbl Standard Quote Sheet,
it is opened by clicking a command Button on the Main
form. i have also created a QuoteInputBox form that has 2
unbound text boxes on it that opens when the
StandardQuoteJobNum form opens what i want the
QuoteInputBox form to do is when i put in a value in the
text controls to find the corresponding record on the
StandardQuoteJobNum Form and set the focus on that record
and then close the QuoteInputBox form when it is done, if
the record is not found or does not exist i have an error
msgbox that i have created to popup and let the user know
that there is no such record. i know how to use the find
record method but i am not sure how to make the data from
the text boxes look up the record on the
StandardQuoteJobNum Form.

any help would be great Have A Great 4th of July.

Greg
 
the following code snippet finds a record on the
StandardQuoteJobNum based on your entries on the
QuoteInputBox form:

StandardQuoteJobNum.RecordsetClone.FindFirst "[SearchCriter
ia1]='" & txtTextBox1 & "' AND [SearchCriteria1]='" &
txtTextBox2 & "'"
StandardQuoteJobNum.Bookmark =
StandardQuoteJobNum.RecordsetClone.Bookmark

if you are searching based on numeric values, remove the
single quotes and cast the value of the two textboxes to
the appropriate type (e.g. CINT(txtTextBox1))

hope this helps
 
the following code snippet finds a record on the
StandardQuoteJobNum based on your entries on the
QuoteInputBox form:

StandardQuoteJobNum.RecordsetClone.FindFirst "[SearchCriter
ia1]='" & txtTextBox1 & "' AND [SearchCriteria1]='" &
txtTextBox2 & "'"
StandardQuoteJobNum.Bookmark =
StandardQuoteJobNum.RecordsetClone.Bookmark

if you are searching based on numeric values, remove the
single quotes and cast the value of the two textboxes to
the appropriate type (e.g. CINT(txtTextBox1))

hope this helps
 
Back
Top