fill table based on which button is pressed

D

Daniel M

I have a form that has 2 command buttons. I need to put a value into a table
based on which one is pressed. IE: close or open if the button close or open
is pressed. this should go in the same column of the table. any ideas?
thanks.
 
T

tina

you're not specific as to whether you want to add one or more new records to
a table, or update one or more existing records in a table. as a general
answer, you can create an action query to perform either action, and run the
query from the command button on the form, using the OpenQuery action.

hth
 
A

Amy Blankenship

Have you tried just binding a radio button groups to the column, with close
or open as the radio button values?

HTH;

Amy
 
D

Daniel M

I wanted to hide the control of open or closed so i dont want radio buttons.

I also have been having problems with running it in a qry. This is a linked
excel file so any updates throws a popup saying are you sure you want to
update the linked table. :( Currently i have a text box with the default
value of "Open" in it. This submits it just fine when the open button is hit
but i dont know how to change it when the closed button is clicked. I am
trying to do it with simply submiting/saving a record not updateding one.

dm.
 
Top