Search results for query: *

I would like to be able to submit data from my form into the table but if it is already in the table then create a new entry. So at times, the advisor will be the same along with other fields but I want each entry to be its own and not overwrite other entries. Here is some of the code: If...

So when I code it to populate the recordset do I say if me![name of option button or option group?].value = true (or do I put the actual value I gave each box in the properties) then rst.edit rst![vtd1].value = true rst.update Thank you!

I want to use a bound object frame and put 3 option buttons in this frame. I then want to say if this option button is checked update the rst with a value of true and if this optino button is checked, update the rst with a value of true etc. However, I want the users to only have the ability...

Is there anyway to clear all field values in a form in one statement? thank you -

I am trying to find out if the customer id is already in the table: Set dbs = CurrentDb() str = "SELECT [CUSTOMER DATA].* FROM [CUSTOMER DATA];" Set rst2 = dbs.OpenRecordset(str) If Me![CustAcctID] = rst2!CustAcctID Then MsgBox "This Customer already exists in...