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...
Thank you for your reply. My PK is unique. I am wondering if there is some type of code that should be in the On Current Property. When I input my PK (which is called Catalog Number) it does not display the contents on my form or subform. When I tab down to the subform I am getting an error...
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...
I am still having the same issue mentioned before:
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.