Search results for query: *

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...

Wow...thanks for all the suggestions. I will try these and see what happens. Appreciate the help.

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...

Figured it out. sql = "Select * From Contents Where PartNo= """ & Me!txtPartNo & """"

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...