Record Selection in Filtered SubForm

M

MeTed

Maybe I'm overthinking this, but my Access is a few years on the rusty side
so I apologize. I have a combo box on a main form with Customers. I'm
passing to the subform filtered Ship To addresses based on the selection in
the main form. My question is this. Is there a way (either in Datasheet
view or Continuous Form view in the subform) to put a check box in my
filtered results so when they click on the Ship To address they want it will
stuff the [ShipToID] into my Orders table?


TIA....
 
G

Golfinray

Yes. The information entered on a form SHOULD automatically be saved to your
table. To just be sure, I generally put a command button on my forms for
save. The command button wzard will set that up for you. If you wanted a
check box to do the same thing, just use the same code the command button
uses and then delete the command button.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top