Pop Up Form Query

[mesci]

Hi!

I have a problem with a combo box in my form, which when having specific data selected from it (e.g. in this case "Distance Delivery") displays a pop-up form to request information from the user.

Unfortuantely I can't seem to make the pop-up form display only the current record (rather than all of the records) without messing up the first macro.

If anyone can help, I'd be very grateful.

At present the macro is very simple just to open the form where it ="distance delivery"

Cheers in advance for any help!!

 

[BLeslie88]

Question....

where it ="distance delivery" Can this not result in multiple records using distance delivery as a filter..?

Would you not need to specify : where it = "Unique Record ID" for the selected record from the combo box even if they are selecting a distance delivery.......?

Another thing to know would be are you controlling the record source through VBA or just assigning it through data source on the form...?

 

[mesci]

Hi, thanks for responding,

in answer to your queries, I don't think it would be feasible to us just the Distance Delivery spec as a filter, as ideally I just want the one specific record to show (as it will be non-access users inputting data and I'd rather data wasn't able to be misplaced)

I haven't as of yet found the need to specify where "unique id record" instead of distance delivery - as I believe it will make the aspect of the pop-up form redundant.

I'm working hard at it anyway, if anyone else has any ideas or has come across this before please let me know. I'll also post up if I find the solution.

Many thanks anyway!!!