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

Problem in append table

suriacute85
P: 6
Hi,

I'm very new in Ms Access, i have a form which contain a sub form table, i also have text box for data entry. when i enter the data, and click the add line button, the data will automatically save and view in sub form. the problem is, now, i want the data move to a new table and after that, the data in the subform disappear when i click button save.
how can the data move to another table and the data will not view in sub form when i click the save button? Please help me.. I'm desperate.
Aug 14 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,396
Hi,

I'm very new in Ms Access, i have a form which contain a sub form table, i also have text box for data entry. when i enter the data, and click the add line button, the data will automatically save and view in sub form. the problem is, now, i want the data move to a new table and after that, the data in the subform disappear when i click button save.
how can the data move to another table and the data will not view in sub form when i click the save button? Please help me.. I'm desperate.
Why have a subform at all then? Sounds like you can just use unbound controls and use a DoCmd.RunSQL "INSERT ..." on button click.
Aug 14 '07 #2

suriacute85
P: 6
i have another problem, in my form, i have a sub form which i take the record from my table T_LogEntry, after i click save button, i want the record in the sub from move to my another table called, T_EntryData. and automatically, the record in the sub form will disappear. will U help me?
Aug 15 '07 #3

Rabbit
Expert Mod 10K+
P: 12,396
i have another problem, in my form, i have a sub form which i take the record from my table T_LogEntry, after i click save button, i want the record in the sub from move to my another table called, T_EntryData. and automatically, the record in the sub form will disappear. will U help me?
I refer you to post #2 because this is the exact same question.
Aug 15 '07 #4

Post your reply

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