By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,041 Members | 1,793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,041 IT Pros & Developers. It's quick & easy.

Enter New Data In Comboboxes Only

P: n/a
In my custom menu one menu item opens a form to add new Makes to TblMakes and
another menu item opens a form to add new Models to TblModels. I have a form
that has a combobox for Makes and a combobox for Models. In both comboboxes I
use the NotInList event and code to allow users to enter Makes and Models that
are not in the database. When the form is open, I want to limit the users to
entering new Makes and Models in the comboboxes and not going to the menu items
at the top of the screen. How do I do this??

Thanks for all help!

Kathy
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Sun, 21 Dec 2003 04:04:35 GMT, "Kathy" <kb*****@earthlink.net>
wrote:

Set the form's Data Entry property to True.
Since you want to use the forms both ways, I would suggest rather than
making a copy of the form, using a bit of VBA to set this property
dynamically. Use the OpenArgs argument of Docmd.Openform to pass in a
hint as to which mode you want. Then in form_open, check the hint and
set the property accordingly.

-Tom.

In my custom menu one menu item opens a form to add new Makes to TblMakes and
another menu item opens a form to add new Models to TblModels. I have a form
that has a combobox for Makes and a combobox for Models. In both comboboxes I
use the NotInList event and code to allow users to enter Makes and Models that
are not in the database. When the form is open, I want to limit the users to
entering new Makes and Models in the comboboxes and not going to the menu items
at the top of the screen. How do I do this??

Thanks for all help!

Kathy


Nov 12 '05 #2

P: n/a
Tom,

Thank you for replying!

How does this keep the users from going to the custom menu when the form with
the comboboxes is open?

The problem with the users going to the custom menu and entering a new Make or
Model is that after they enter it, it still does not appear in the drop downs of
the comboboxes. The comboboxes would need to be requeried. That then presents a
problem when Makes or Models are entered via the custom menu when the form with
the comboboxes is not open.

Thanks!

Kathy

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:61********************************@4ax.com...
On Sun, 21 Dec 2003 04:04:35 GMT, "Kathy" <kb*****@earthlink.net>
wrote:

Set the form's Data Entry property to True.
Since you want to use the forms both ways, I would suggest rather than
making a copy of the form, using a bit of VBA to set this property
dynamically. Use the OpenArgs argument of Docmd.Openform to pass in a
hint as to which mode you want. Then in form_open, check the hint and
set the property accordingly.

-Tom.

In my custom menu one menu item opens a form to add new Makes to TblMakes and
another menu item opens a form to add new Models to TblModels. I have a form
that has a combobox for Makes and a combobox for Models. In both comboboxes I
use the NotInList event and code to allow users to enter Makes and Models thatare not in the database. When the form is open, I want to limit the users to
entering new Makes and Models in the comboboxes and not going to the menu itemsat the top of the screen. How do I do this??

Thanks for all help!

Kathy

Nov 12 '05 #3

P: n/a
Check for the form being loaded, and if it is, requery the relevant comboboxes?
Nov 12 '05 #4

P: n/a
On Sun, 21 Dec 2003 19:24:49 GMT, "Kathy" <kb*****@earthlink.net>
wrote:

You make the form lodal. That way they can't access the menu.
It's one of the arguments in DoCmd.OpenForm.

By the way, I would likely have only 1 form: the parent form to add
makes, and a subform to add models. That way models are automatically
associated with the correct make.

-Tom.

Tom,

Thank you for replying!

How does this keep the users from going to the custom menu when the form with
the comboboxes is open?

The problem with the users going to the custom menu and entering a new Make or
Model is that after they enter it, it still does not appear in the drop downs of
the comboboxes. The comboboxes would need to be requeried. That then presents a
problem when Makes or Models are entered via the custom menu when the form with
the comboboxes is not open.

Thanks!

Kathy

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:61********************************@4ax.com.. .
On Sun, 21 Dec 2003 04:04:35 GMT, "Kathy" <kb*****@earthlink.net>
wrote:

Set the form's Data Entry property to True.
Since you want to use the forms both ways, I would suggest rather than
making a copy of the form, using a bit of VBA to set this property
dynamically. Use the OpenArgs argument of Docmd.Openform to pass in a
hint as to which mode you want. Then in form_open, check the hint and
set the property accordingly.

-Tom.

>In my custom menu one menu item opens a form to add new Makes to TblMakes and
>another menu item opens a form to add new Models to TblModels. I have a form
>that has a combobox for Makes and a combobox for Models. In both comboboxes I
>use the NotInList event and code to allow users to enter Makes and Modelsthat >are not in the database. When the form is open, I want to limit the users to
>entering new Makes and Models in the comboboxes and not going to the menuitems >at the top of the screen. How do I do this??
>
>Thanks for all help!
>
>Kathy
>


Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.