dynamictiger
Registered User.
- Local time
- Today, 13:23
- Joined
- Feb 3, 2002
- Messages
- 270
I have been playing with this for a few days.
I have a table set up for personal details, name, email. This is the form, we will call main form.
Then there is a subform for phone numbers. So the person can have as many phone numbers as you input.
Another subform on the main form displays the address that this client currently owns.
There is a subform within this subform that displays details about the address.
So far so good.
However, if we want to input a new user, what this form does, then how do we default the last subform to the existing record.
So far I have tried:
Creating a query that finds the match, if there is one.
I then count the occurences and if there is more than 0, I tried reassigning the recordsource to the query and requerying the subform. That didn't work.
I tried reloading a different subform, based on the query - but that doesn't work.
I tried reassigining the recordsource and resetting the source object - that doesn't work.
Anyone got an idea?
I have a table set up for personal details, name, email. This is the form, we will call main form.
Then there is a subform for phone numbers. So the person can have as many phone numbers as you input.
Another subform on the main form displays the address that this client currently owns.
There is a subform within this subform that displays details about the address.
So far so good.
However, if we want to input a new user, what this form does, then how do we default the last subform to the existing record.
So far I have tried:
Creating a query that finds the match, if there is one.
I then count the occurences and if there is more than 0, I tried reassigning the recordsource to the query and requerying the subform. That didn't work.
I tried reloading a different subform, based on the query - but that doesn't work.
I tried reassigining the recordsource and resetting the source object - that doesn't work.
Anyone got an idea?