Hi Everyone,
Please let me know how to add new record in unbound form.as i tired using inbuilt add new button but its not working.
Hi Everyone,
Please let me know how to add new record in unbound form.as i tired using inbuilt add new button but its not working.
Why don't you just use a bound form and make life easy for yourself. Just curious.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
I'm sorry but I don't understand your reply.What do you mean that you can't select the data and what would you do with it if you could.if i use bound form then i'm not able to select any data in sub formWhy?if i save data then data saved 2 times in table
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
You probably need to review main form/subform design principles because you must be doing something wrong with that. There's tons of info/videos out there to help you.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Based on this I suspect that your main form and subform are both based on the same table...is that correct?
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Forgot to address why the native 'add a record' button didn't work.
it doesn't work because you can't add a new record to an Unbound Form! In point of fact...an Unbound Form doesn't contain any Records! It only contains data that can then be used to create a Record in a Table.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Yes you are correct, main form and subform are both based on the same table.Can you tell solution for this problem?
Why would you have a Main Form and a Subform based on the same Table? That makes no sense! This configuration is employed to show Records from different Tables that are related to one another...usually with a single Record in the Main Form's Table related to multiple, related Records in the Subform's Table.
If it's a question of having a crowded Form, Control-wise, consider using a Tabbed Control with Controls on multiple Pages.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Not that I care for them a lot, but if you must have a form that looks like a main form/subform but is based on the same table, then you might want to take a look at split forms. They are 2 views of the same data.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.