Setting up a default in a check box based on an after update question/help!!!

[d9pierce1]

Hi all,
I have a combo (CboCompanyType) that selects the "Company Type" from a query. I also have a check box on that called "Primary" in that query.
I am having problems coming up with a code as to when i select a "CompanyType" from the dropdown, i want it to see if it all ready has a primary type
in the query where "CompanyID=" CompanyID
If it does, then msgbox "Primary all ready exist, would you like to replace?"
If yes, then remove the record that all ready set to primary and make this record primary.
If no, then cancel
If it doesnt have a Primary value yet in the query then
Call Primary Click
Something to this efect, not even sure how to say this clearly?
Basically looking to make a check box for a Primary but only allow one per CompanyID if
this make sense?



Primary_OnClick()
If Primary = 0 then
MsgBox "Would you like to set as Primary?"
'If Yes then set value to check box = -1
'If No then cancel=True

CboCompanyType_AfterUpDate()
'Check to see if table/Query all ready has a primary where "CompanyID=" CompanyID
If Primary = -1, then


MsgBox "Primary all ready exist for this company! Would you like to replace?"
'Yes then set Primary Value to = 0 for the one that is all ready checked
'and set primary value for this record to =-1
'If no, then cancel = true

Thanks
Dave

[isladogs]

No it really doesn't make sense and is not helped by your vague terminology
What exactly is the point of what you want to do?

Are you trying to change a primary key field using code?
Are you talking about a primary key field or a yes/no field (badly) named Primary?
A Yes/No datatype would NEVER be used as the primary key field

[d9pierce1]

Hi, the chkbox nane is primary, it’s not primary key...

[d9pierce1]

For all purposes let’s make “primary” default. Seeking to make one record a default with in a query where the companyid is = to the companyid in the combo

[isladogs]

You really need to change the name of that checkbox
There is no such thing as a default record.
Nor can you refer to a default yes/no field or checkbox control.
Perhaps you mean default value? I really don't know

Hopefully someone else will have more idea but I have no clue what you mean.
Sorry. I will drop out now

[d9pierce1]

Just skip it, not worth the name of the field! Have you ever been to PayPal and had multiple addresses when it asked you if you want to make this address the default?

[isladogs]

Now that finally makes sense.....
The easiest way is to set all records for that yes/no field to false using an update query or sql equivalent .
Then set the required record as true with a second query/sql filtered to the specific record based on its primary key field.

Hope that makes sense to you. Good luck

[d9pierce1]

Thank you very much

[isladogs]

You're welcome. Glad we got past the initial confusion.