Delete all rows from table on form load

[LarryJ]

I have 2 controls with a row source of a table. I have the form load event set to a procedure that deletes * from both tables. The issue is, when I insert rows into those tables, the controls don't show the inserted rows. Should I be emptying the tables at a different time (i.e., not on form load) or empty them a different way?

[pbaldy]

That's a little confusing, but you may need to empty them in the open event rather than the load event. Or requery the form after emptying the table.

[LarryJ]

I moved the deletes to the open event and added a requery for both controls there and in the function that loads data to them. Everything is now working as intended. Thank you.

[pbaldy]

No problem.