Need a Text box in a form to access a field in another table

I

Iram

Hello.
I am using Access 2003 and I am running into a little dilema.

I have a form called "frm_Input" that is controlled by a query called
"qry_Input" that is controlled by a table called "Tbl_Master". In this form I
have a unique record identifier called "Code" which gives every record its
uniqueness.

I have another field called "PhotoName" in this form that needs to access
(read/write) a field called "PhotoName" in a different table called
"Tbl_MasterContinued". Both tables are linked by the unique identifier.

The problem is that I need to be able to modify the "PhotoName" from teh
"Tbl_MasterContinued" field from two seperate forms. Each of these two forms
connect only to their respective tables only. I was trying to create an
expression in the "PhotoName" field to look up the table
"Tbl_MasterContinued" with the same unique identifier on the form to allow me
access to that field. I have tried adding the "tbl_MasterContinued" to the
qry_Input query but it doesn't work as expected...


I am going in circles, can you help me figure out how to do this?

Thanks.
Iram/mcp
 

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

Dcount question 8
Clearing combo boxes and a text box 2
Delete all data after a symbol in a field 0
Help creating a search form in Access XP 0
Setting column width in a table with a macro is not working 0
Autonumber field in Excel that behaves the same as Access 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Dynamic Naming of Form Button 3

Top