displaying cleared form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a database to keep track of employee time off. I mass updated 12
holidays into the database before adding any time off for any of the 26 pay
periods. Since the holidays were added to the database, I cannot get a blank
form to come up for the time cards. Everytime I choose an employee, it
populates the form with the holiday data instead of leaving all the fields
blank. Does anyone have any suggestions on how to solve this issue. I also
tried to use a command button to open the form: (docmd.openform "tc_frm",
acnormal, acadd ) That only brings up the form empty until I select the
employee name.

Matt
 
wheelz said:
I am using a database to keep track of employee time off. I mass updated 12
holidays into the database before adding any time off for any of the 26 pay
periods. Since the holidays were added to the database, I cannot get a blank
form to come up for the time cards. Everytime I choose an employee, it
populates the form with the holiday data instead of leaving all the fields
blank. Does anyone have any suggestions on how to solve this issue. I also
tried to use a command button to open the form: (docmd.openform "tc_frm",
acnormal, acadd ) That only brings up the form empty until I select the
employee name.

Matt
Click to expand...

I'm guessing that you have an employee table, with a related timecards
table. Or, if you haven't, then you should have, and you need to rethink
your database design before worrying about forms!

Anyway, assuming that you have got these two related tables, then what you
need is an employee form, with a timecards subform. If you always want your
subform to be blank, ready for the entry of new timecards, then set it's
DataEntry property to Yes. Otherwise, just click to a new record in the
subform, without changing the employee details shown in the main form.
 
Thanks Brian, that was very helpful.

Matt

Brian said:
I'm guessing that you have an employee table, with a related timecards
table. Or, if you haven't, then you should have, and you need to rethink
your database design before worrying about forms!

Anyway, assuming that you have got these two related tables, then what you
need is an employee form, with a timecards subform. If you always want your
subform to be blank, ready for the entry of new timecards, then set it's
DataEntry property to Yes. Otherwise, just click to a new record in the
subform, without changing the employee details shown in the main form.
Click to expand...
 
Back
Top