Look-up Wizard returning empty pick list

[kp123]

I noticed in my database design that a text field should have featured a drop-down menu, with options therein to pick from.

I have gone into the Design Mode to amend this but have been told that Relationships needed to be deleted. I have done this and then rebuilt the relationships between my forms.



However, while I now have the drop-down feature, the option list is blank!
My source form from which the pick-list should be offering options is populated and the Look-up tab on the Design screen appears identical to other -working! - pick-lists!

What on earth has happened?!

[June7]

You are talking about Lookup in the table design? I NEVER set this in tables. As developer I want to see real values when I look at tables.

Would have to analyse the project to try and determine what has happened.

[kp123]

Hi,

No, not in tables.
I imported some Notepad-based pick-lists into my Access database and identified these files as the source of the drop-down menus in the final forms.
These were coming back blank and churning up error messages about existing Relationships, although I had removed these!

It is fine now though. I made amendment to the original forms and all seems to be resolved.
Sometimes you just need to pick away at the problem. Break it down and it sorts itself out!

Thanks.