Hi. So I am completely new to Access. Just started using Access this week.
So far I have a table and I have created a form from the table. I've also created some buttons but am now stuck on how to make the buttons do what I want. For example, I have 2 buttons named "Yes" and "No". When the user clicks on No, the button should automatically enter the value of "No" into the variable, say, PCI, directly into the table. And when the user clicks on Yes, a new menu should appear asking the user to enter all the dates for when PCI was performed. Again, when the user enters the date values, they should inserted into the table directly. For the No button I tried using the SetValue command in the Macro builder but I can't seem to make it work. I'm not really sure of the syntax but I put in [Table1]![PCI] in Item and "No" in Expression and got an error. And for the Yes button, I have no clue how to begin.
I don't know any VB so hopefully everything I mentioned can be done with the macro or expression builder.
Thanks in advance,
Jimmy
So far I have a table and I have created a form from the table. I've also created some buttons but am now stuck on how to make the buttons do what I want. For example, I have 2 buttons named "Yes" and "No". When the user clicks on No, the button should automatically enter the value of "No" into the variable, say, PCI, directly into the table. And when the user clicks on Yes, a new menu should appear asking the user to enter all the dates for when PCI was performed. Again, when the user enters the date values, they should inserted into the table directly. For the No button I tried using the SetValue command in the Macro builder but I can't seem to make it work. I'm not really sure of the syntax but I put in [Table1]![PCI] in Item and "No" in Expression and got an error. And for the Yes button, I have no clue how to begin.
I don't know any VB so hopefully everything I mentioned can be done with the macro or expression builder.
Thanks in advance,
Jimmy
