Forms text box issue

[shree]

Hi all,

it is regarding forms text box, i have form there are many text boxes they will gives me individual broker or broker ID total using Dsum formula criteria

but problem is where some time new broker is come for that i do not have text box then i have to add new text box for new broker even formula.

it very difficult to do every time. is it possible through macro please advice me!!


Dsum = =DSum("[BAL]","BALANCE","[Broker ID]='A2020'")

[June7]

Programatically modifying design of objects is not something I have ever done and sounds more difficult than just doing the edits. Also, doubt macro can do this, would have to be VBA.

Possibly a subform would be better than a lot of textboxes.

[Missinglinq]

...but problem is where some time new broker is come for that i do not have text box then i have to add new text box for new broker even formula.

I'm afraid your explanation makes little sense! Adding a new Control for each new broker is an activity you would find in a spreadsheet, not in a relational database! In a relational database you have a single Field, with a Textbox that is Bound to it, for entering brokers. When you add a new broker you add a new Record, entering the broker's name in the appropriate Control/Field.

Unless you can give us a better explanation of what you're trying to do, here, I think you really need to follow the directions at the bottom of June7's post and attach your file for us to look at.

Linq ;0)>

[shree]

Programatically modifying design of objects is not something I have ever done and sounds more difficult than just doing the edits. Also, doubt macro can do this, would have to be VBA.

Possibly a subform would be better than a lot of textboxes.

Hi thanks for your reply but what should i do know? please advice

[June7]

Suggestions provided were:

Explore subform arrangement.

Maybe provide your project for analysis.

New suggestion: Maybe you should be doing a report instead of a form.

[shree]

File is attached.

[June7]

Which form is the focus of this issue?

[shree]

Thanks for your prompt reply!! "Form3" you have to type in text0 " AD40123" (i.e. concatenate of Fund and cusip filed) select today's date in text2 and click on click me!! button

there are two text box lable name is BPN AND GSAM its gives us the totals, if in further JP Morgan broker add then i have to add the JP text box again and dsum formulas, this is the exa but in live there are many brokers i can not say which broker when they will exist. that is the actual issue

[June7]

Suggestion:

1. Activate the form Header section. Move all the current controls into Header. Can probably delete the broker DSum textboxes.

2. Set form RecordSource to Balance query. I revised the query to:
SELECT ENTRY.[Broker ID], ENTRY.[Broker Name], Sum(ENTRY.SELL) AS SumOfSELL, Sum(ENTRY.BUY) AS SumOfBUY, Sum([BUY]-[SELL]) AS BAL
FROM INFORMATION INNER JOIN ENTRY ON INFORMATION.CONCATENATE = ENTRY.CONCATENATE
WHERE (((ENTRY.CONCATENATE)=[forms]![Form3]![CONCATENATE]) AND ((ENTRY.[ENTRY DATE])<=[forms]![form3]![ENTRY DATE]))
GROUP BY ENTRY.[Broker ID], ENTRY.[Broker Name];

3. Create 2 textboxes in the Detail section and set ControlSource property to fields [Broker Name] and [Bal]

4. Change the code for Click Me to: Me.Requery

5. Set form to Continuous View

[shree]

hi thanks but could you please attached new amended file
it is good for me to change here as well

[June7]

Suggest you follow the very clear and distinctly outlined steps and modify a copy of your form, if you want to preserve the current form.

[shree]

Hi thanks a lot !! but my totals not coming as i want, i want individual broker total exa GSAM - 2000 BPN - 1000 like that in text boxes if i choose the records source to detail text box it showing only GSAM in broker name and 0 in bal.

[June7]

All the suggested edits worked for me. Post your revised db and will analyze your efforts.

[shree]

hi please have a look and reply please

[June7]

No attachment to the last post.