Hello folks, I hope someone here can help. I have a continuous form of records that include a date in and a date out. When I select a particular record from this list, a pop up form with a combo box appears. From this combo I select a record which then populates the date-in and date-out on the original record from the continuous form. This works perfectly, however, in order to populate the date-in box, I use a query that updates it from [date-in].date() to date-in + 7. It then refreshes the continuous form so that I can see both dates appear in real time. This is working well, until I have to scroll down through the records. When I update the date-in and refresh, the continuous form goes back to the first record, meaning that the record I originally selected disappears from view. My question is, how do I populate both date boxes in real time and get the record (continuous form) to remain where I can see it? It's not a major problem, just annoying. I can scroll down to find the record and confirm that the process was successful. I'd rather it just stayed in view.
Thanks folks
Rob