I am now working on the macro.
I want to show the value of a cell of the table, in a text box of a form.
here are what i did:
1) use "go to control" to the customer_ID field.
2) use "find record" to find the specified ID I want.
3) use "go to control" move to one of the field in this row, e.g. First_Name
What I want to do next is,
use "set value" to move the content of this cell to a text box in a form.
I can specify the destination, but I don't know what I should put in the Expression......
so anyone knows and can tell me?
P.S. one another thing, do you guys know how I can put an open file dialog box, or the fact is I couldn't do so in MS access?
thx a lot
I want to show the value of a cell of the table, in a text box of a form.
here are what i did:
1) use "go to control" to the customer_ID field.
2) use "find record" to find the specified ID I want.
3) use "go to control" move to one of the field in this row, e.g. First_Name
What I want to do next is,
use "set value" to move the content of this cell to a text box in a form.
I can specify the destination, but I don't know what I should put in the Expression......
so anyone knows and can tell me?
P.S. one another thing, do you guys know how I can put an open file dialog box, or the fact is I couldn't do so in MS access?
thx a lot