Bring up value to another form

  • Thread starter Thread starter Lili
  • Start date Start date
L

Lili

Hi,

If I just add a customer in a new customer form and I
have a button to go to sales form, when I cick it, is
there any way so that the sales form can show that
particular person ID/name?

Thank you.
 
Im assumming you have a macro sitting behind this
button. You want to edit the macro and use the
WhereCondition function. Where you have the openform part
of the macro, enter the WhereCondition in the properties
for it. Use something similar to the code below.

[Customer Name]=[Forms]![Customer Details]![Customer Name]

The left side is for the form being openned and the right
side is for the form you are navigating from.
 
Greetings,

I am also trying to get one form to bring up a record in another form. I
have a filtered form that lists all the records in the database by last name
by alphabet. I want to click a record to have it display a specific record
on a form in which I enter and edit data. I have put your snip or code in
the macro changing it to match my form and field names and it returns an
empty record. The macro uses the OpenForm action but I cannot find a way to
get to the spcific record.

Any thoughts on what I have missed or done wrong?

Many thanks.

Best regards,
Scott

Neil said:
Im assumming you have a macro sitting behind this
button. You want to edit the macro and use the
WhereCondition function. Where you have the openform part
of the macro, enter the WhereCondition in the properties
for it. Use something similar to the code below.

[Customer Name]=[Forms]![Customer Details]![Customer Name]

The left side is for the form being openned and the right
side is for the form you are navigating from.
-----Original Message-----
Hi,

If I just add a customer in a new customer form and I
have a button to go to sales form, when I cick it, is
there any way so that the sales form can show that
particular person ID/name?

Thank you.
.
Click to expand...
Click to expand...
 
try to create the open form command button
in my case, the specific rrecord does not show because I
am trying to bring up a sale that the customer doesn't
have.
 
Back
Top