How to ....

[Guest]

Hi

I am new to access so I will like some assistance with code to perform a task.

I have created a form called Trade Interface, this form has fields of
Symbol, Description etc. The trade interface form is tied to the trade data
table, however the fields mentioned above are tied to another databse called
symbols. The description field is a combo field.

I would like to have a button on the trade interface form, which would open
a new form, to allow users to enter new symbols and descriptions as needed.
Once the information is entered I wish to have it saved to the symbols
database and the user returned to the trade interface form.

Could someone assist me with the code to perform this task.

Thanks so much in advance.

Regards

 

[Rob Oldfield]

I'm not exactly sure that I get what you're after, but have you looked at
just linking the relevant table from the symbols database?

 

[Ronald Roberts]

Hi

I am new to access so I will like some assistance with code to perform a task.

I have created a form called Trade Interface, this form has fields of
Symbol, Description etc. The trade interface form is tied to the trade data
table, however the fields mentioned above are tied to another databse called
symbols. The description field is a combo field.

I would like to have a button on the trade interface form, which would open
a new form, to allow users to enter new symbols and descriptions as needed.
Once the information is entered I wish to have it saved to the symbols
database and the user returned to the trade interface form.

Could someone assist me with the code to perform this task.

Thanks so much in advance.

Regards

Not sure what a combo field is, but if you are using a combo box control
on the "Trade Interface" form, look at the NotInList properity for the
combo box.

Ron