Pull ID from another form..autonumber
Posted on 2000-01-05
I have two Id's on a form. One should be pulled from form1, and the other is an autonumber.
How can I place the ID in a global variable and then reference it in all forms?
Is the autonumber causing my DBGrid not to add any new records. Before having any ID fields, the Grid worked fine. Once I added the two ID's, I can't add any new records. I physically went into Access and forced an entry for the CustomerID (the one I want to be global). When I went back to VB I could see that 1 record, however, I still can't create a new record through VB... If I click and type on any field, nothing happens. When I try to resize the column, it beeps, then gives me a space to add a new record, however, when physically adding in the correct CustomerID, I still can't add a record.