popup address form

  • Thread starter Thread starter Karen Skipper
  • Start date Start date
K

Karen Skipper

I have a table of product information. There are fields to record the sale
of a product and then fields to record the return of the warranty card for
that product.

On my form I have the ability to search for a product by code and serial
number. There is the possibility that a product/serial number combination
will occur more than once (if the product is returned and we can resell it).
I want to retrieve the product/serial number and use the navigation buttons
to find the correct record if there are more than one for the prod/serial
number. Now I want to have a button that will show me the address which is
not shown on the main form (lack of space and not everyone wants to see
that). When I click my button I get the address from the first record with
that product/serial number combination, not the record I'm looking at on the
main form.

Any suggestions?

Karen
 
Filter the record source for the popup form by

Me.Filter = "RecordID = " & Forms!MainForm!CurrentRecordID
Me.FilterOn = True

in the Current event of the popup form.
Pavel
 
I'm sorry, I don't quite know how to interpret the
Me.Filter="RecordID"... line. Is RecordID a variable?

I understand where you mean to put this code.

Karen
 
I got in now! Thanks to Pavel's information and some research in the VB
help file. I just wasn't looking in the right place earlier.
 
Back
Top