how can i refer to the current cell in a table?

I

ivanbbq

Joined
Nov 15, 2005
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Create option group without using wizard? 2
How to Update Source File IncludeText from a Target File if Source in a Text Control? 0
Word Adding a watermark to a table 1
Searchforrecord does not appear to work 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Square character(s) in cells 2
Access Table match or lookup or other method 0
Excel If a Cell Contains a Certain Text (From Another Table) 0

Top