Check Box To Cancel Opening Of Pop Up Form 2

[pjd218]

I have an unbound form that pops up after loading the bound form with instructions on filling out the fields in the form.

What I would like the user to be able to do is cancel the pop up (unbund form) by checking a check box (just like the Start Up screen on most software programs where you have the option to prevent it from opening automatically again).

Currently, the form is called by code by the On timer event and a slight delay for the main page to load (thanks AceMan)

Any suggestions?

 

[MazeWorX]

Yes/no field in a table .. in your code to open the form
something like this

have the form with the checkbox bound to a yes no field in a table

then in your forms timer event

If(dlookup("[YesNo]", "tblWhatever")) = 1 then
Exit sub
Else
Open the form
end if

untested



HTH << MaZeWorX >> Remember amateurs built the ark - professionals built the Titanic [flush]

 

[TheAceMan1]

To All . . .

For reference ... this is a followup of thread702-1563183

I forgot to mention to [blue]pjd218[/blue] to mention this reference of continuation in this new thread.

[blue]MazeWorX[/blue] ... your on track with your initial post.

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[pjd218]

Yes, Ace Is correct.

He has helped me out too many times to count.

maze, thanks for the reply.

Will give it a go tomorrow. Rigging the boat for a sailfish trip at 0430 in the AM.

Ace, you are the man!

 

[TheAceMan1]

[blue]What I would like the user to be able to do . . .[/blue]

This is indicitive of more than one user and [blue]the core[/blue] of your post! If the db is on a network or users are opening the same db ... [blue]then you want the checkbox response [purple]stored[/purple] for each user[/blue]. Hence [blue]MazeWorX's[/blue] table suggestion.

In the [blue]current state of the db[/blue] ... [purple]are you able to Identify users?[/purple]

[blue]your thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[MazeWorX]

Sorry about that AceMan didnt realize it was a follow up to another thread

M

HTH << MaZeWorX >> Remember amateurs built the ark - professionals built the Titanic [flush]

 

[pjd218]

Maze,

My apologies for the continuation thing.

Ace, this will not be on a network so I will give Maze's suggestion a go.

Thanks to both.

 

[TheAceMan1]

[blue]Sorry about that AceMan didnt realize it was a follow up to another thread[/blue]

No No No! I had [blue]pjd218[/blue] start a new thread because [blue]I thought the subject was one many would be interested in and get involved![/blue] Simply exposing the subject to the forum.

So please ... [blue]do get involved![/blue] ... anyone!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[pjd218]

MazeWorx,

How exactly would I create a bound control on a popup form that is essentially unrelated to the main form?

Tried setting the control source of the check box to a yes/no field I added to the table, but when I try to check the box, will not allow me to select the checkbox.

 

[MazeWorX]

Create A table with one field called disable and set the record source for the popup to it then bind the Check box to the table. Assuming that once this is diabled it will not been seen by any user. The best way would be to write it to a table of users that way in a multi user environment your users can individually decide. As Ace had asked above with multiply users are you able to identify them in the db's current state?

M

HTH << MaZeWorX >> Remember amateurs built the ark - professionals built the Titanic [flush]

 

[pjd218]

Maze,

I came up with a work around that calls a custom help form when the user clicks on a help button.This is consistent with other forms in the application.

The help window then opens off to the side of the main form so the user can see the data entry fields and still view the help.

Thanks for your suggestion.