Blazer Saga
Registered User.
- Local time
- Today, 07:53
- Joined
- Jan 22, 2007
- Messages
- 12
I have been looking for a similar post to my problem for an hour now and the closest I could find is http://www.access-programmers.co.uk/...reset+rec ord
I have a Form, Form1, with a sub form, Sub1, that are links threw a text field that is the primary key for both of them. Sub1 is hidden by default but not disabled. There is a check box on Form1 to toggle displaying of Sub1 and deletes the record form Sub1 when it hides the field.
Everything works fine, I can edit fields, advance and go back threw Form1, and Sub1, will update its fields appropriately. The problem comes in when I add a record to Form1. Form1 defaults out its fields correctly, but when I display Sub1 it still shows all the data from the last record on Form1. If I either change the record and then switch back or go to click in the field it blanks out the form correctly.
How do I get it so Sub1 will show the right data correctly the first time? Is the some place I need to put a requery in?
I have a Form, Form1, with a sub form, Sub1, that are links threw a text field that is the primary key for both of them. Sub1 is hidden by default but not disabled. There is a check box on Form1 to toggle displaying of Sub1 and deletes the record form Sub1 when it hides the field.
Everything works fine, I can edit fields, advance and go back threw Form1, and Sub1, will update its fields appropriately. The problem comes in when I add a record to Form1. Form1 defaults out its fields correctly, but when I display Sub1 it still shows all the data from the last record on Form1. If I either change the record and then switch back or go to click in the field it blanks out the form correctly.
How do I get it so Sub1 will show the right data correctly the first time? Is the some place I need to put a requery in?
