Forms changing tables!!!

[jedcomyn]

please can someone help......


I have a form that facilitates data entry into a database table. I have several combo boxes that allow choices e.g. firms : ANB Amro, Merrill Lynch, etc.

The combo boxes contain data that can be found in other tables ie tblfirms .

I want to be able to choose from the combo box to input into the database AND ALSO type other names into the box that will input not only into the database table BUT also add to tblefirms . Thus increase the options in the combo box.

This means i only have to update the database form and options within the combo boxes will increase.


Many thanks in advance.

Jed

 

[jedcomyn]

First timer...

As a newbie i am just following what would be useful.... however this is my first db andso i am really trying everything out. What would you recommend i do?

The only reason i'm doing it is so that i don't have to constantly update the tbls for the drop down menus when i get a new firm or job type.

Thank you for the link, and i'm grateful for your words of wisdom

jed

 

[jedcomyn]

Update tbls?

Will limit to list update the combo tbls?

I need to have an entry that is not in the combo box to appear in future combo boxes on the other forms.

Jed

 

[jedcomyn]

Not sure

Hopefully it will stabalize but there may be times when the required firm is not availible and instead of adding it to the tbl it would be easier to just add it to the combo box, I might add a msgbox that will appear if there is a new name added that will say something like : Are you sure you want to add " firm name .


Thank you for your help,

Jed

 

[jedcomyn]

Frustration

It is so frustrating:

I know what i want to do: I want to add code to the AfterUpdate row in the Combo box properties that does this

######################################
IF ' name typed ' is in tblfirm then goto to next box,

however if ' name typed ' is not in tblfirm

then open msgbox with ' Are you sure you want to add name typed to the list?

if the answer to the msg box is yes then add ' name typed ' to tblefirm and goto next box.

if the answer is no then return to the combo box
#############################

But i'm really bad at vb can you help?

(i will post this in vb as well)

Thank you so much

jed

 

[Rich]

Use the NotInList event for your message box, search here for examples