How many text boxes can you ref onto a mainform? 1

[techkenny1]

Hi all,
On a subform I have 12 text boxes which holds Currency values. I wanted to reference these to the mainform. I can get 10 of these to work but not the other two.
To test the error I have deleted two of these and substitued the other two, and they work ok.
Is it that you can only refernce up to ten text boxes onto a mainform.

Or is there another way of doing this?

many thanks,

KP

 

[dhookom]

There isn't a normal limit causing your issue. Your main issues are:
[ol][li]You didn't provide any results, only "these to work but not the other two"[/li]
[li]Again you haven't provided names of controls or what you entered into the control sources.[/li]
[/ol]
You have posted about 60 questions here and should realize what types of information are critical for success in getting good answers.

It might also be helpfull to provide information on why there are 10 currency text boxes and why they need to be referenced on more than one form.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

If you can put it on the form you can reference it. You can add up to 754 controls over the lifetime of the form (includes deletes). So you are doing something wrong as Duane is pointing out.

 

[TheAceMan1]

How are ya techkenny1 . . .

[blue]On a subform I have 12 text boxes which holds Currency values. [purple]I wanted to reference these to the mainform.[/purple] I can get 10 of these to work but not the other tw.[/blue]

Reference them in what way? ... Referencing controls is an easy thing to do! ...

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[techkenny1]

Hi Guys,

Many thanks for your replies. I will detail what I an tring to do.
The mainform is a client form (FrmClient) amd the subform is a form with rates. Each client has up to 25 providers, all with different rates. So trying to invoice thsi can be a problem.
The subform (CoRates) has 12 different rates. All these apply to every client.
So there is a 'day rate, night rate etc. the currency text boxes are labelled as above.

On each text box on the mainform , I have put on the contro l source the following, =CoRates.Form!Dayrate; CoRates.Form!Nightrate and so on untill all the rates are on the mainform.
The first 8 text boxes return the rates as correct. The last two text boxes, CoRates.Form!SpRate; CoRates.Form!PHRate; These two do not work. What I did was to disable the first two text boxes and the last two finally worked. When I enabled the code back to the first two text boxes, the last two did not work again. Hence my question on how many text boxes on a mainform will work.

Many thanks,

KP

 

[dhookom]

I wouldn't even reference the subform. The subform has a record source based on a table or tables. Take advantage of this to pull the rates.

However I expect you have an unnormalized rate table. If your statement "12 different rates" means you have 12 fields then I would change the structure. I could be wrong since you haven't provided your table structures or which tables are bound to which form and subforms.

Duane
Hook'D on Access
MS Access MVP

 

[techkenny1]

Hi dhookam,
Thanks for reply. One of the problems is that we bought this company with this datbase. Until we can get enough finance to get another Db then we have to keep this one going.
The base relationship is a company table with a rate table and a client table in a many to many relationship. As you can see it can pose many problems.
I thought about your last post on how it could be done more effectively. So I have now changed the whole structure of relating rates to clients. etc. Now when a company is selected per client it will change rate values for that company. Hence there should be no more errors in generating invoices.
So hopefully this should be more effective.

kp