I Put the selected field because I was thinking of changing the yes/no field to a group box with yes =1 no=2 & N/A =3.
I will work on your suggestions and maybe by next year I'll have something to show you . you said it: it looks simple but it really is not.
VilaRestal: I appreciate your input. I will study further and get to the bottom of this. What other tables would you add? Thank you again for your assistance. If you ever come to NYC please let me know, I owe you lunch!
Thank you for having the courage and time to help me.
I attached my project to make easier to communicate. If you load frmPunchInspect you will see the basic layout I did. I added a button where I'm putting this code in the On Click Event
Private Sub btnSave_Click()
Dim strSQL As String
'if...
Good evening everyone.
I used to know how to do certain little things in Access, but that was a long time ago. I didn't know much about access or developing then and I know less now.
I have a table called tblPunchlist with the fields - ID_Punlist, id_room, id_item, YesNo. In this table I...
Thank you for your prompt reply John. Where do I put this code? Do I still leave the requery on Form B. Please keep in mind that the Requery is for Form A through Form B but sometimes Form B is loaded without loading Form A so the requery becomes invalid.
Hello Everyone:
I have one button on Form A that calls Form B. In Form B I have in Private Sub Form_AfterUpdate():
Forms!FormA!CbComboBox.Requery
End Sub
It works fine if I call Form B from Form A, but if I load Form B by itself (not from the button, but directly) I get an error message when...