Populating Form Fields From Another Form

[JeffG3209]

This is a tricky one for me.



I have a form named "TRACER". It's record source is a table "DATABANK"

I would like to create another form "LEGEND".

"LEGEND" needs a field from "TRACER" named "amount".

I have tried adjusting the record source for about an hour to no avail. I read over this and tried to plug a few things in, but I can't seem to figure it out!

Any help, pointers would be greatly appreciated

[NoellaG]

Hi,

I suppose the datasource of the form LEGEND is another table in your database. If you need the field AMOUNT (that is, as I understand it, in the table DATABANK) you need to chance the datasource of the form LEGEND into a query that contains all the fields from the second table + the field DATABANK.AMOUNT.
If there is no link between the two tables and the data need to be shown on one form, you should probably look at ypur database structure.

greetings
NG