Create a record on a table by pushing a bottom
-
- 2StarLounger
- Posts: 119
- Joined: 01 Jul 2013, 14:08
Create a record on a table by pushing a bottom
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.
-
- 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
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
Hans
-
- 2StarLounger
- Posts: 119
- Joined: 01 Jul 2013, 14:08
Re: Create a record on a table by pushing a bottom
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
-
- 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
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?
Can you edit existing records in the subform?
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 119
- Joined: 01 Jul 2013, 14:08
-
- 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
And do you get a new, empty record if there are no existing records?
Best wishes,
Hans
Hans