anyway I can use dlookup in access 2k from the table design view ?

[Keith Handley]

Basically what I want is a drop down based on a subselect based on the value
of a just entered field data

Its a doddle using forms but I cant use forms in this case (dont ask its a
long story)

Basically I have 2 tables

Table1
ReportName text
ReportID text

Table2
GenDesc text
ReportName text
ReportID text

I have a lookup defined for a select Reportname from table1 defined for the
lookup for table2.Reportname That works fine but When entered I want to
default the Table2.reportID to the reportID that matches the Reportname from
Table1

Thanks for any ideas

Keith

 

[John Vinson]

Its a doddle using forms but I cant use forms in this case

Then you can't use DLookUp. Table datasheets are very limited.

 

[Tim Ferguson]

Its a doddle using forms but I cant use forms in this case (dont ask
its a long story)

.... but you never can't use forms...


Tim F