I am using access 2007.
I have a form that lists address records. The user can select a record from the form to edt (using address detail form) or click new address command to add a new address. This fuctionality works fine.
I have an entry authoriation record that contains the addressID to the address records created above.
I have an entry authorization form which lists the records to edit them(authorization detail form) and has a command button to make a new authoriztion - when I make the new autorization record, it also allows me to make a new address record as well.
My problem is there may be times when I want to select an existing address and then make a new authorization record.
I added a new authoriation command button to the address detail form. I added code to pass the address info via openargs to the authorization details form which is opened acAdd.
When I added code to the OnLoad event of the authorization form and passed the address info to the form - I received an error on the address id field saying that I wasn't allowed to enter a value for it.
I must have a design issue - but I can't figure out how to fix it.
Any help would be appreciated.
I have a form that lists address records. The user can select a record from the form to edt (using address detail form) or click new address command to add a new address. This fuctionality works fine.
I have an entry authoriation record that contains the addressID to the address records created above.
I have an entry authorization form which lists the records to edit them(authorization detail form) and has a command button to make a new authoriztion - when I make the new autorization record, it also allows me to make a new address record as well.
My problem is there may be times when I want to select an existing address and then make a new authorization record.
I added a new authoriation command button to the address detail form. I added code to pass the address info via openargs to the authorization details form which is opened acAdd.
When I added code to the OnLoad event of the authorization form and passed the address info to the form - I received an error on the address id field saying that I wasn't allowed to enter a value for it.
I must have a design issue - but I can't figure out how to fix it.
Any help would be appreciated.
