Question Lookup ‘Row Source’ doesn't exist?

[Monkey_Vs_Robot]

Hello all.. I hope you can help. I’ve not been able to find an answer by googling, but that might be because I’m not asking the right question!

I’m trying to import data into a database developed by someone long gone for the organisation.

The first field is ‘StudentID’, which has a lookup row source type of ‘Table/Query’ and the row source is called ‘StudentLookup’.

I can’t however find a table or query called ‘StudentLookup’… what else could this be if it’s not a table or query?

Thanks! A.

 

[Estuardo]

g'd afternoon,
If you get results from that tbl/qry is because exist, but is probably hidden.
You don't say which is your access version, but look for the navigation pane options and mark the "Show hidden Objects" option. That should work.
G'd Luck

 

[Monkey_Vs_Robot]

thanks for your reply, Estuardo..

interestingly, nothing appears in the drop down and it won't allow you to type an ID (even copying the ID from the row above).. i just get a 'the text you entered isn't an item in the list'.

Adding records from the front end form works but just can't manually add a student ID to the table.

 

[Estuardo]

It might be safe to remove that row source.
g'd luck