Find Correct Record with multiple key

[redman08]

I have a problem as follows:I have a form, with fields to edit. The data is keyed on a 'text identifier', which is entered and then used. I then determine if there are multiple occurrences of the that key (it's annoying, but possible).The single occurrence of the 'text identifier' is no problem - at the moment. If there are multiple occurrences, I use a combo to select which date the user wants. I then try and select the correct record using 'text identifier' + Date.

This is where I am having trouble. I have tried 'filtering' and 'find record', but get various issues with null data being returned.

I'm sure there must be a simple efficient way of achieving this.

Many thanks in advance.

[nico5038]

I would change the textfield into a combobox and use cascading combo's (Check: http://bytes.com/topic/access/insigh...mbo-list-boxes)
You could check after the first field has been selected or there's no data for the second combo and proceed directly.

Nic;o)

[redman08]

Thanks for that. The reason why I used a textbox and not a combo for the first key was that there will be thousands of records to choose from initially.

But, if that's the only/best way, then I'll have ago.

Thanks again.

[nico5038]

The advantage of the combo box is the "auto append" feature. When typing a code Access will append the first matching number. Just give it a try :-)

Nic;o)

[redman08]

Have tried your approach, and linking the combos is fine (this wasn't a problem anyway). Once I select the date (on the second combo), I still get 'null' data coming through, as it doesn't appear to be able to fix onto a record with the 'identifier' plus 'date' put together as a search key. Again I've tried (in 'date_combo' afterupdate) to use filter, or similar.

[nico5038]

How does your filter gets constructed ?
Be sure that the date needs to be embedded in #'s and strings (when your code is a text field) in single quotes.

Nic;o)

[redman08]

Thanks Nic.

Problem solved.

I'd assumed that the date returned in the combo didn't need to have "#" surrounding it - but it did!

Many thanks again.

[nico5038]

No thanks needed, glad I could help and success with your application !

Nic;o)