Sub Form controls

[access2010]

In our MsAccess 2003 database we want to use the form = Investment_Transactions_Main = to allow the continuous entries of (Buying & Selling) transaction.

My problem is that when I choose a = Stock Name = or Symbol Stock = the corresponding data for the chosen equity is not grouped in the sub form and I can not enter new records.

Your assistance is appreciated.

Thank you
Mary Jane

[June7]

First, advise you not use special characters such as #, $, / in names. Use Num or No for #, just drop the $, use _ instead of /.

If you want to enter data into record with those two comboboxes, they should be in the Detail section. Really shouldn't save Stock_Name or Symbol_Stock or Symbol_Stock_Y, just Investmentl_ID.

If those controls are for input of filter criteria then they should be UNBOUND.

And what do you mean by 'grouped'? Forms do not group records. You can sort and filter. Reports can group records.

[arnelgp]

add a Sort Order to your subform 's recordsource.

[access2010]

Thank you for your suggestions, of not using the symbols you advised us of. Our problem is that these characters have been used for over 10 years and to change them is very difficult, BUT we will not be using these characters in the future.

===

Please advise us as to how we can use the chosen Stock Name or Stock Code to group the equities in the Sub Form?

Where should the combo boxes be so that we can use them to group the equities together for editing?

Your assistance is appreciated.

Nicole

[arnelgp]

here. view the code on the AfterUpdate event of those combos on the main form.

[access2010]

Thank you for your assistance and what you have supplied us with works.
Could you please look at the attached RTF document for some changes that our Volunteers would like to have, if you could do them for us.

If you happen to be in Cebu, one of our staff is going there soon and could bring you a bottle of Canadian Maple Syrup.

I/We do appreciate your assistance.
Nicole

[access2010]

I am sorry but the RTF file was not uploaded

[arnelgp]

what do you mean by Group? summarized?

Create new record does not work

done.

Up and Down scroll bar does not work on the Sub Form

done, but you must be inside the subform. use Up, Down arrow keys.

Up and Down scroll bar does not work on the Main Form

done. use the Up, down Image.

How can we have a comma added to the numeric stock quantity

see the controls Format Property.

[access2010]

Thank you for your assistance.
===
Create new record (my code) does not work
We purchase a new Equity for example, Arnelgp, how do we enter the purchase details?
===
Thank you for fixing
Up and Down scroll bar does not work on the Sub Form
Up and Down scroll bar does not work on the Main Form
===
How can we have a comma added to the numeric stock quantity?
Our Volunteer group manager would like to see the
= Shares Bought Total = Shares Sold Total= and Shares Currently Owned Total= values for each equity group with a comma separator ie; 2,345.
===
“NZ”
In some cases there is no quantity in the field Shares Sold #, therefore I thought we had to have =NZ = in the totaling code
===
I/We do appreciate your assistance.
Nicole

[arnelgp]

sorry my access is complaining when adding code to the new form i made. there is incompatibility issue. i only have a2016 x64. your db is created in earlier ver.

[access2010]

Hello and thank you for your note.

One of our machines has Office 2017, should I try and convert the file for you?

Thank you.
Mary Jane

[arnelgp]

yes please.

[access2010]

All of the later versions of the MsAccess software programs we have, find that the file that you have been helping us with is buggy and we will start anew.

Paul