Create a record on a table by pushing a bottom

User avatar
sistemaPR
2StarLounger
Posts: 119
Joined: 01 Jul 2013, 14:08

Create a record on a table by pushing a bottom

Post by sistemaPR »

Do you know how to create a record on a table by pushing a bottom ... And then refresh the form in order to display a subform based on that new record.

User avatar
HansV
Administrator
Posts: 78632
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Create a record on a table by pushing a bottom

Post by HansV »

Do you merely want to create an empty new record? Or do you want to fill in some fields in the new record, and if so, where do the values of those fields come from?
Best wishes,
Hans

User avatar
sistemaPR
2StarLounger
Posts: 119
Joined: 01 Jul 2013, 14:08

Re: Create a record on a table by pushing a bottom

Post by sistemaPR »

It would be an empty record but with for the customerID of the record on the form, this record is going to be filled by the user. This table (related by the customerID) is a questionare of 16 question and comments. I have a subform but because there is no records it show blank ( nothing), It would nice to click a bottom that create a Record for that customerID. Is like creating one for only some of the customers. A way around is, I could write a record for every customer of the table, but that is not what I want. what you think

User avatar
HansV
Administrator
Posts: 78632
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Create a record on a table by pushing a bottom

Post by HansV »

If there are no existing records in the subform, it should display an empty new record. If it doesn't, that makes me suspect that the subform is not updateable, which would make it impossible to add a new record.
Can you edit existing records in the subform?
Best wishes,
Hans

User avatar
sistemaPR
2StarLounger
Posts: 119
Joined: 01 Jul 2013, 14:08

Re: Create a record on a table by pushing a bottom

Post by sistemaPR »

now I can

User avatar
HansV
Administrator
Posts: 78632
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Create a record on a table by pushing a bottom

Post by HansV »

And do you get a new, empty record if there are no existing records?
Best wishes,
Hans