Hi, I need some help on the followi

[sggmm]

Hi, I need some help on the following problem.

I am thinking to create a form which allows user to input certain information (say field1, field2,...,field5). Table1 will stored information on field1, field2 and field3 and Table2 will save information on field1, field2 and field5). Can I do something like this?

Thanks

 

[RickBerem]

Hi,

Yes you can.

you should use a Form and a sub form.
Form linked with Table1
subform with table2

For FIELD1 and FIELD2 you can copy them in invisible fields on the subform(meaning there is going to be 2 field1 and 2 field2 one on each form.) and copy the value to the second in the LOSTFOCUS event doing a code looking like

Forms("SubForm&quot.txtCopyOfField2 = me.txtField2

If i'm not clear enough let me know.
Hope it Helps! Salvatore Grassagliata
GrassagliataS@hotmail.com

 

[WildHare]

A correctly designed join query with the fields you want should be very easy to set up (given the limited information in your post).

Then base a form on your query, and you should be all set. No code necessary.

If this doesn't/won't work, you'll have to come up with some additional detail on your problem.

Jim



How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm