Case function Issue

[Paul Cooke]

Hi Guys could someone advise me how to resolve an issue I have with the following please.

I have a subform set as continueous. I have various controls of which two are cascading combo's.

I have a case function on one of the controls to show the dose numbers used for a particular vaccine as follows:

Case "Avaxim 0.5ml Hepatitis A Vaccine"
        Me.cboDoseNumber.RowSource = "VaccineDose2"

The problem I am getting, is that as I choose a dose number from the combo the same number appears in the record below. Is there a way to only have it appear in the current record? Im am thinking along the lines of adding a 'if isnull' line to the case function to check the product control has been selected.

Just not sure if this is the most efficient way to do this?

Many thanks

 

[JANR]

The problem I am getting, is that as I choose a dose number from the combo the same number appears in the record below

That is the behavior of continious forms and datasheet forms, the only way around this is to hide/unhide the combobox.

Check out the samplebase Continiouscombo here: http://www.databasedevelopment.co.uk/examples.htm

JR

 

[Paul Cooke]

Many thanks Jr - I thought as much just hoping there was an easier fix !

Thanks again