Must I (also) re-create a new Form?

[Rich_Lovina]

I have a form based on a query which i now can't find. Is that possible?
Anyway the Form is happily working away, and now I decide (developer on-the-run) i want to link a new table to that form, so I can show a related table field.

Viz.:
Form has field X!Table A, Table B has field Y, which I now want to 'appear' on the Form.

Must I re-create the Query and the Form (wuth all its nice design colours, and coding), or is there some way to just 'tie' that form to a new query?
(Boy this was real easy in Lotus Approach!!!)

 

[Rich]

You can't find the query? I suspect that the query is actually the SQL contained as the record source. Look on the property sheet for the form under record source. If it's the sql copy and paste it into a new query you can then add the relevant table/fields you require. Either save the query and change the forms record source to the query or paste the newer sql back as the record source. Or you could use DLookup on the new table, depends what you want to do with the new field.
HTH

 

[Rich_Lovina]

Rich, Tks for the tips. The Record source has the same name as my table, but there's no qry by that name also, but I'll try the other options you suggest.

 

[Rich]

If the record source has the table name then it's based on the table not a query. Access will not let you have a table and query with the same name.
HTH

 

[Rich_Lovina]

Tks, I think the answer's obvious now.