Table Linking Form

[Kavy]

Good Afternoon (Depending on Location I guess),

I have created a main form from a table that has two fields: 'Account' and 'Date'. There is a subform that is created from a separate table which shows transactions for each entry in the main table.

My question is, when I change the combo box in the main form for 'Account', it actually changes the Account in the table, how can I make my subform change to reflect the transactions for the new account shown, instead of changing the data in the table?

Thank you for any tips

Kavy

 

[Montez659]

I am not 100% on what you are meaning, but if you want to add new transactions to post on the subform to the current account opened in the main form, you would just start filling in the info in the new row on the subform (supposing that it is in datasheet mode).

Also, if you need to, you can change the types of objects in the subform as well to be comboboxes to pick from a table.

 

[Kavy]

Thanks for the reply

I think were close, my problem is my combo box picks from a table (i.e. only has data which exist in the table), but when I change the value in the combo box, it changes the value in the table.

I would like it to leave the value in the table alone, and go to a new record based on that selection

 

[xenou]

See here:
http://allenbrowne.com/ser-03.html

Note that he is using an unbound combobox - you populate this combobox with accounts. The "real" account field will be a hidden field in the same form. When you select an account in the combobox, the form will move the record for that field. Often I will synch the value in the combobox when the form opens, so it isn't empty.

 

[Montez659]

Ok, when you say that you want to go to a new record when you change the combobox, do you mean a new subform record, or a completely brand new record. Maybe a little more info on how you have this all set up will help me out.

How do Accounts and Date relate to each other? You mentioned savings and such in your other post, should I be thinking of this like a bank account? If so, are you trying to tie different accounts to the same contact info, and then different transactions to those different accounts?

 

[Montez659]

Note: I am happy to keep helping you but will be unavailable until Fri morn CDT.

 

[Kavy]

Ok, when you say that you want to go to a new record when you change the combobox, do you mean a new subform record, or a completely brand new record. Maybe a little more info on how you have this all set up will help me out.

How do Accounts and Date relate to each other? You mentioned savings and such in your other post, should I be thinking of this like a bank account? If so, are you trying to tie different accounts to the same contact info, and then different transactions to those different accounts?

Thank you for your patience Montez, and thank you xenou I think you hit the nail on the head!