clearing form

B

Billiam

I have a main form based on t_Timesheet. This form has several fields, which
have default values poulated in most of them. Sometimes I need to use a
command button on this form to launch a second form which is also based on
t_timesheet.

The problem is, afer I enter information on the launched form, I notice in
t_Timesheet, that the main form items (from default values) have also been
entered.

So, how do I stop the Main form from entering its default data when I enter
data in the launched form?

Thanks for any help!

Billiam
 
J

Jeff Boyce

It would probably help us help you if we knew more about how those forms are
"fed". What are the queries you use to fill those forms? Feel free to post
the SQL statements so we can better understand.

And it all starts with the data... what is the table structure of the data
underneath?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top