I have two tables: tablea and tableb
tablea has two fields: amountdue and duedate
tableb has three fields: amountdue, amountpaid and paiddate
I have a query that looks in tablea and selects the records that have a due date of the current day which works.
I have a tasks form with the query as a subform
Now how can i get the records from the query into tableb when i open my tasks form. I only want the amount due field from the query to go into tableb.
Thankyou folks
J
tablea has two fields: amountdue and duedate
tableb has three fields: amountdue, amountpaid and paiddate
I have a query that looks in tablea and selects the records that have a due date of the current day which works.
I have a tasks form with the query as a subform
Now how can i get the records from the query into tableb when i open my tasks form. I only want the amount due field from the query to go into tableb.
Thankyou folks
J