I have 4 checkbox on a form when they are checked trueI want to append the MemberID to a table.
That leaves the ServiceID null,
If check box A is true 1 want the serviceID to be 1
If check box B is true 1 want the serviceID to be 2
If check box C is true 1 want the serviceID to be 3
If check box D is true 1 want the serviceID to be4
i cannot use an update after the record insertion because I want to create a unique index.
I thought of changing teh default value bit I am using a SQL server 2005 back end with an MS Access 2010 front end
Microsoft SQL ServerMicrosoft Access
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.