my existing table consist of address of new customers. the data is entered as work order tags are received. my portion of the database is to add to the existing data "AFTER" invoices are received and approved.
My portion is fairly easy, look up the address, check the box paid, add the date, and invoice number. well it sounds easy but there's about 100 address to look up, and only "Some" address within a certain street name is ready.
what I've been doing to make somewhat easier is I created a simple query on the street name, and I'm able to pick n choose the address based on the invoice.
I'm wanting to make it even easier, I'm wanting to 1), query based on the street name, 2), select "paid", based on the actual address in the invoice, and 3), have the date, and invoice fields completed after the "paid" invoice has been checked.
I created a continues form based on the query that brings them up, but because the form is populated by a query, I can't perform any updates. this is where I'm stuck. not sure where to go from here.
any suggestions would be greatly appreciated.
My portion is fairly easy, look up the address, check the box paid, add the date, and invoice number. well it sounds easy but there's about 100 address to look up, and only "Some" address within a certain street name is ready.
what I've been doing to make somewhat easier is I created a simple query on the street name, and I'm able to pick n choose the address based on the invoice.
I'm wanting to make it even easier, I'm wanting to 1), query based on the street name, 2), select "paid", based on the actual address in the invoice, and 3), have the date, and invoice fields completed after the "paid" invoice has been checked.
I created a continues form based on the query that brings them up, but because the form is populated by a query, I can't perform any updates. this is where I'm stuck. not sure where to go from here.
any suggestions would be greatly appreciated.