Updating text boxes on a form based on a combo box cascade

[Marianne160]

Hi,

I know there are various answers to this problem available on the web but none of them seem to work for me. I am using Access 2003 to make a form to look up data from a table. I have so far created three combo boxes that cascade down from Name to Project to Date and when this has been chosen I have four textbox fields I want to display based on this selection. I tried linking the last combo box comboDate to update these fields after update by the following:

With Me
.Lead_Name.Value = .Date.Column(1)
.Action_Timescale.Value = .Date.Column(2)
.Bus_contact.Value = .Date.Column(3)
.Actions.Value = .Date.Column(4)
End With

but it doesn't work the boxes remain blank after selecting from the drop down box and I have checked that they are included in the combobox list.
Anyone have anyidea why it isn't working? I'm presuming it might be because it is just basing it on the date which in the database as a whole is repeated for different projects and not linking it to the above comboboxes.
How do I get around this?

Thanks, I really hope that makes sense to someone!

Marianne


P.S. I did manage to get this to work when the last combo box was only linked to the one above i.e. project but not name but as there are multiple projects with the same name I can't use this. I have both type of formed saved (one with the comboboxes all linked but the text boxes not updating and one with the text boxes updating but the dates listed not filtered by the original name).

[clbrewster]

You listed the name of the combo box was comboDate so shouldn't the code read

With Me
.Lead_Name.Value = .comboDate.Column(1)
.Action_Timescale.Value = .comboDate.Column(2)
.Bus_contact.Value = .comboDate.Column(3)
.Actions.Value = .comboDate.Column(4)
End With

[Marianne160]

You are of course entirely right I worked this out a little while ago and its now working fine so thanks for that, how embarassing!However I still have a problem, one of my text boxes should be a memo but the long entries are cut off ending sometimes halfway through a word any idea why this might be?

[stonward]

I reckon you need to set the Multiline property to Yes....

[Marianne160]

As far as I'm aware it already is a multiline text box it has multiple lines before it halts abruptly and a scroll bar that you can scroll but the area is blank.
I'm not sure where the multiline option is though it doesn't seem to be in the properties.
Appologies for being a bit clueless,

Thanks

Marianne

[stonward]

No apologies needed....I'm not a real 'expert' yet...just I saw your question and thought I could help...

Wot about the size of the field...set in the table design? What have you got that fields size set to?

Stonward...

[Marianne160]

I don't think the size is the probelm its a large text box but cuts off after just a few lines leaving a large area of white space even before you scroll down.

[stonward]

No, No, No...

The table that holds that textbox's data...there is an attribute called 'field size'; what is that set to?

[Marianne160]

Sorry for the delay in replying I have been away.

The original table does not have a field size as it is a memo field and so does not have this attribute.

I have found out why the field is truncating though although I am not sure there is anyway to fix it. Basically the combo box cascade that preceeds the text box is essentially a query and in order to sychronise the text boxes with the combo boxes I have added the addition columns to the query which causes the memo field to truncate. I have tried telling the total to be first with all the other columns as group by but this seems to have absolutely no affect.

Am I fighting a losing battle or is there a way of linking my combo box with a text box on a form so that the memo is still displayed completely?

Thanks Again

[stonward]

Sorry M...been away from the Forum myself for a while.

Have you solved your truncating issue?! How about using text (rich text setting) instead of memo?

Regards

StonwardR