By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,561 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Info on form to enter into table

P: 22

Is it possible to have a field on a form copied from another form (aka =[forms]![formname]![fieldname]) enter that data that it copies into a table even though it is just a reference? I need that information in a table to keep the relationship, but don't want users to have to type it into the form.

I tried playing with append and make table queries but have never used either and was not very successful. Any thoughts?
Oct 4 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418
Yeah this is possible...

With code in VB

In your form properties go to After insert event procedure and type

Me![Aka]=Forms![fdfd]![sdsd] ' as you've done well in your post

So every time when a new record is inserted this value will be copied from the respective form!

Oct 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.