MS Access Reading Data from one form to another

[Doll]

I need some help please. I need to show data as disabled but visible
on 1 of my forms that is linked up to another table.

For example: I have 2 forms and 2 tables. Form A is linked to table
A. Form B is linked to Table B. The cost field is from the
componentcost table and linked to on Form b, but I want it also to show
up on Form A but form A is linked to the inventory table. I only need
it to show up on Form A for viewing purposes only, but I don't know how
to get that information to show up on Form A. I've tried a subform that
doesn't work. I've tried code. This code sorta works but only takes
the first number value in the table and its the same value on each
record. Its not changing when I scroll from one record to the next in
sync with the records on Form B. I hope I"m making sense - any help
would be so very much appreciated! Wendy

Dim db As DAO.Database
Dim rs As DAO.Recordset

Set db = CurrentDb
Set rs = db.OpenRecordset("SELECT Components.Cost FROM Inventory Right
JOIN Components ON Inventory.Component = Components.ID;")
txtComponentCost = rs!Cost
txtComponentCost.Requery

[david epsom dot com dot au]

You need to link your Form A to a Query instead of a Table.

The query can join Table A and Table B, so you can show the
cost field on the inventory form.

(david)

"Doll" <ws*********@yahoo.com> wrote in message
news:11**********************@t31g2000cwb.googlegr oups.com...

I need some help please. I need to show data as disabled but visible
on 1 of my forms that is linked up to another table.

For example: I have 2 forms and 2 tables. Form A is linked to table
A. Form B is linked to Table B. The cost field is from the
componentcost table and linked to on Form b, but I want it also to show
up on Form A but form A is linked to the inventory table. I only need
it to show up on Form A for viewing purposes only, but I don't know how
to get that information to show up on Form A. I've tried a subform that
doesn't work. I've tried code. This code sorta works but only takes
the first number value in the table and its the same value on each
record. Its not changing when I scroll from one record to the next in
sync with the records on Form B. I hope I"m making sense - any help
would be so very much appreciated! Wendy

Dim db As DAO.Database
Dim rs As DAO.Recordset

Set db = CurrentDb
Set rs = db.OpenRecordset("SELECT Components.Cost FROM Inventory Right
JOIN Components ON Inventory.Component = Components.ID;")
txtComponentCost = rs!Cost
txtComponentCost.Requery