Master and Subform linked field causing subform to display no records

[SeadnaS]

I have a master form with a subform in it. I have 4 fields linked between the two. The subform is set to datasheet view. I have a text box on my main form called RANGETXT this displays the range of values of the field x1 displayed on my subform. Now i need to write the range to the table that my subform is bound to. I created a field on the subforms bound table (this table is called child) called RANGE i linked the textbox on my main form (RANGETXT) to RANGE on my subform. Now my subform won't show any records. When i enter a record and move to the next row the last one disappears! Before i linked RANGE and RANGETXT this didnt happen and i could see the records I had previously entered.

Any help much appreciated! Is it something to do with the control source of RANGETXT? Its =[range].[Column](0,0) this is a listbox.

Thanks in advance!

 

[TheAceMan1]

SeadnaS . . .

Reading your post again I believe I may have been premature. When you started talking ranges I assumed [blue]Excel[/blue]. If true I was right ... if [blue]Access[/blue] then your in the right forum.

Sorry for any confusion.

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[SeadnaS]

I'm using access! Its OK though I should have been clearer! I've posted this on the Access VBA forum now as well though. Can I delete that thread or does a mod have to do it?

Also I'm still having major trouble with my db. I've moved away from what I was trying above. Basically I need to get the range of the numbers on my subform and write it into a column on the subform. The way I was trying above kept causing the subform to show no records. I can upload a copy of the DB if needs be.

 

[TheAceMan1]

SeadnaS . . .

You really should give more thought to what you post. Always ask yourself if tipsters are going to understand what you mean. Remember ... we don't know whats in your head and can't see the db directly. Example:

[blue] Basically I need to [purple]get the range of the numbers[/purple] on my subform and write it into a column on the subform.[/blue]

I've read the above quote five times and would be forced to ask: What range of numbers? From where? Why transfer to a column on the same subform? These items are truly not clear.

As for uploading the db, I'll take a look just bear in mind AceMan is using 2003 and you may have to convert first. A big help would be a screenshot of your [blue]relarionships window![/blue]

[blue]Your Thoughts? ...[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[SeadnaS]

Sorry for the confusing post. I struggled to describe what I was looking for! I was trying to get the range of a series of numbers entered into a subform and write them to a table. But it was causing problems with how my subform displayed records for some reason. Turns out I didn't need to write the range to a table after all. I wrote a query that got me where I need to be! I can't beleive I didn;t think of that! I'm still a beginner at access I guess!