using a form to open a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form I use to view a report. the form contains a combo box with
product names. The report brings up information on whichever product is
selected from the drop down list. The problem is when I try and close the
form, access automatically tries to save what was entered in the combo box.
I don't want to save the product names because they are already saved and I
have selected no duplicated values. So, my question is, how do I close a
form without saving it?
Thanks
 
Nikki,

Set the recordsource property of the form in design view to blank.

HTH,
Josh
 
If your form is used solely to run reports, it probably should not be
bound to the underlying table. The combobox will only be used to
provide report criteria.
 
Thanks for the tip. I think that is exactually what I need to do, however.
When I deleted the record source that read "products", the field on the form
read #NAME? and I couldn't select any products from the list. Do you know
why this happended and what I need to do?
thanks again!
 
Nikki,

Also blank the controlsource property of the combo box.

HTH,
Josh
 
You must log in or register to reply here.

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

Similar Threads

Keep my Form Open 6
Use form to select criteria for report 4
View criteria used to filter a report 2
How to select all months from a table to include in a report 3
Using data stored in a combo box 2
Access Passing the value to a table 1
Form with combo box to set criteria for query and report 2
Access Automatically Send a notification email once a record is added 0

Back
Top