If I want a form for data entry and another also at the same time with some addl info from another table linked to the first one (the second is Read Only just to make some info available to the user at the time of data entry), how can I do this?
For example, I have a data entry form giving details of some invoices. Now the user has to refer to another table just for checking some old details pertaining to the same invoice. Those details are available in a table which is linked to the first one through a combo box (viz., the invoice no for the first form/table is taken out of the second table containing the old information)
Any ideas?
Thanks for your time and patience
Rao

Hi Rao,

Just make another form bound to the information you need and call it, say, from a command button. Suggest you read up on Pop Up forms in help.

Hope this helps,


Clive Astley

You can also have the other support form as a subform inside of your main form (say on the bottom or side). When you move from record to record on the main form, the subform (if linked properly) will automatically display the info right there without having to click any buttons.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks to both of you
I already worked out the first one
Now I will do the second which is so obvious that it did not strike me
Rgds
Rao

Have you tried locking the fields in question? (The ones that you do not want your users to change?)