B
birdbyte
I'm clueless about how to acheive updating records in a table via an
Access 2000 form. I have a textbox on a form that a user enters a value
(an appointment number). I'm trying to get a series of date fields (10
of them total) to automatically populate when that text box loses focus
(or After Update?). I'd like to check the textbox to make sure a 2 was
entered, and if it was, then have the 10 fields populate with dates 6
months apart from each other. I've figured out a query to manufacture
the dates, but I'm not sure how to get that information to the table. I
tried an append query triggered to fire when the box lost focus, but
wasn't sure how to get it to only append if the appt num was 2.
Any guidance, ideas, examples are appreciated.
Access 2000 form. I have a textbox on a form that a user enters a value
(an appointment number). I'm trying to get a series of date fields (10
of them total) to automatically populate when that text box loses focus
(or After Update?). I'd like to check the textbox to make sure a 2 was
entered, and if it was, then have the 10 fields populate with dates 6
months apart from each other. I've figured out a query to manufacture
the dates, but I'm not sure how to get that information to the table. I
tried an append query triggered to fire when the box lost focus, but
wasn't sure how to get it to only append if the appt num was 2.
Any guidance, ideas, examples are appreciated.