is this possible to assign a value in VBA

[chevyimpala]

Can you assign a value to a certian table when a user selects a value in a list box.

ex. user has 4 tables, each getting the same data. on the form they can select broker, currency, and account.

Now what i need to be able to do is when the user selects all accounts each account (except fund) will get a value of sys1 in the account field, and fund will get the value that they originally picked. Is this possible.

Thx.

Ivan

 

[mgolla]

Yes this can be done but how would the user select all acounts?

If you are using a list box you could use the OnClick event procedure to assign the value of sys1 to any field in any table. There are also some other options but it depends on how you have the user select the accounts.

 

[JeremyNYC]

Ivan,

There is a problem with your table structure. You would gain a lot by reading some about the subject of "data normalization". There's a great article on my website (I didn't write it), in the Developers' section, under "Fundamentals".

You should not be storing the same value in more than one place in your database.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.