Startup Form

S

Scott Viney

Good morning All,

I have created a form with a group of toggle buttons in a frame. One for
each office. I want the user to select an office from the toggle buttons to
set as their default and store this somehow. For the first time. So that
when the user goes to print the report their office address phone number etc
is at the top of the form. I have all the office addresses etc in one
table.

1) How can I store a value from this startup form only once? Iam thinking
using a table, but how do i get the value from the toggle button to the
table? Of is it better to use a custom property in the files property
dialog box?
2) Once I have this value stored somehow. How do I then make my report
choose the correct row of information from the office table?

Any help on this would be appreciated,
Scott V
 
G

Guest

Just leave the form open and the data will stay.

Use the stored data as criteria in query that you use as source for the
report. Refer to the form like --
[Forms]![YourFormName]![YourTextBoxName]
 

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