Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Create Sequentiaql Numbering on a Subform
Need to know how to code a field to autonumber on a subform while I am inputting. I have a field that I want to start at 1 each time I go to enter a record. I want the field to sequentially increment from there and then I will save the record. When I go to enter a new record the field will...- cschmid
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
Unable to Edit Form and Subform
Posted this awhile back and it is still happening: I have a form and subform that will not allow edits and I receive and error that it will create duplicate values in the PK when I try and edit any information. This happens right before I tab into the subform and have made changes to fields on...- cschmid
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Form and subform will not allow edits
I have a form and subform that will not allow edits and I receive and error that it will create duplicate values in the PK when I try and edit any information. This happens right before I tab into the subform and have made changes to fields on the main form. I have the properties set to yes...- cschmid
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
-
Returning matching records when data is text
I found this example in a previous thread in which the user enters a number in a textbox (PartNo) and the code returns the matching recordset from selected fields in the same table. Code works when PartNo is a numeric data type but in my case PartNo is a text data type (example: D1345). How...- cschmid
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
