HOW DO I UPDATE TABLE FIELD RECORDS FROM A FORM?

[Guest]

I would like to use my form to enter new information into a table. The form
currently contains combo boxes with drop downs for products. As new products
are added, I would like the product to autopopulate in the original table and
be available in the combo box the next time it is used. I have the "limit to
list" property set to "no" to allow data entry which it does, but it does not
appear in the combo box.

Any help would be GREATLY appreciated.

 

[Carl Rapson]

I would like to use my form to enter new information into a table. The form
currently contains combo boxes with drop downs for products. As new
products
are added, I would like the product to autopopulate in the original table
and
be available in the combo box the next time it is used. I have the "limit
to
list" property set to "no" to allow data entry which it does, but it does
not
appear in the combo box.

Any help would be GREATLY appreciated.

Have you tried requerying the combo box after the new product is added?

Carl Rapson

 

[John W. Vinson]

I would like to use my form to enter new information into a table. The form
currently contains combo boxes with drop downs for products. As new products
are added, I would like the product to autopopulate in the original table and
be available in the combo box the next time it is used. I have the "limit to
list" property set to "no" to allow data entry which it does, but it does not
appear in the combo box.

Any help would be GREATLY appreciated.

Where and how are you entering the new product? I'd suggest using a Form
popped up by the combo box's NotInList event; properly setting the Response
argument to acDataErrAdded will refresh the contents of the combo.

John W. Vinson [MVP]

 

[Guest]

I am so new at this, I do not know how that would work. I have built tables
and forms.... I went and made a query from one of the tables that I want to
update from my form, but I do not know how to use it....

 

[Guest]

I am using a form and with your response below, I do not know where or how to
enter a response to an argument.

 

[Guest]

I created the pop up form and now just need to know how to link to the
product entry point.

 

[John W. Vinson]

I created the pop up form and now just need to know how to link to the
product entry point.

I have no trace of a clue what you mean by "product entry point". That's not
an Access term that I've ever seen!

What Forms do you have?
What are their Recordsources?


John W. Vinson [MVP]

 

[Guest]

When I said product entry point, I meant the combo box on the form. I have a
regular form and a pop-up form. My record sources are 2 seperate tables.

 

[Guest]

The pop up form now refreshes the table I need it to, how do I get it to pop
up in the other form when I am entering information that is not on the list?

Hate to be a pain!

 

[John W. Vinson]

When I said product entry point, I meant the combo box on the form. I have a
regular form and a pop-up form. My record sources are 2 seperate tables.

The combo box has a "Not In List" event which is a VBA sub; see the online
help in the VBA editor for Not In List for sample code. RESPONSE is one of the
arguments to the NotInList event - if you set that argument to acDataErrAdded
it will tell Access that you have added a new record to the combo's rowsource
and it will be requeried and displayed.

John W. Vinson [MVP]

 

[John W. Vinson]

The pop up form now refreshes the table I need it to, how do I get it to pop
up in the other form when I am entering information that is not on the list?

Correct the error in your code.

Since we can't see the code, it's more than a bit difficult to help you do so!

Please post the code you're using now and indicate what it's not doing that
you want done. Do you in fact have code in the Combo Box's Not In List event?

John W. Vinson [MVP]

 

[Guest]

YOU GUYS ARE AWESOME! With a litte help from you and a little help from help,
I got it! Now, it's just .... can I do it again?
Thanks!