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

Programatically Enter Data Into Another Form

P: n/a
My data has 10 accounts.

Two forms are opened simultaneously. Form1 is unbound and displays three
records:
Account Quantity
101 17
104 25
107 13

Form2 is a bound continuous form displaying records for all 10 accounts. The
records in Form2 include the Account#.

How can I programatically enter 17, 25, and 13 from Form1 to the Quantity field
in the records in Form2 where the Account#s are 101, 104 and 107 respectively?
The intent is to enter what's in Form1 into Form2, view the data from Form1
along side other data in Form2 and when Form2 is closed, save the data.

Appreciate all help!

John
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
John,

When Form1 is unbound, how can this form show records?
Also: Immediately when you go to another record in your Form2 the former record is saved.
Only the last changed record will be saved when you close the form, the other records are saved
earlier.

If you are trying to validate input before it's *really* saved, you might want to enter data in a
temptable in Form1.
Then (if needeed) maybe in a subform you can show all kind of data from the current record
(account).
Use a validation-flag and set the flag to True when validation-rules are met. Use a boolean-field
(Yes/No)
Add a routine to the closing-event of the form to add the validated record(s) to your *real* table.
You can use a simple query to do this.

--
Hope this helps
Arno R

"John" <jy****@Earthlink.net> schreef in bericht
news:EH*****************@newsread3.news.atl.earthl ink.net...
My data has 10 accounts.

Two forms are opened simultaneously. Form1 is unbound and displays three
records:
Account Quantity
101 17
104 25
107 13

Form2 is a bound continuous form displaying records for all 10 accounts. The
records in Form2 include the Account#.

How can I programatically enter 17, 25, and 13 from Form1 to the Quantity field
in the records in Form2 where the Account#s are 101, 104 and 107 respectively?
The intent is to enter what's in Form1 into Form2, view the data from Form1
along side other data in Form2 and when Form2 is closed, save the data.

Appreciate all help!

John



Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.