Simulate Lookup Field Functionality on Data Access Page - Access 2000

J

jennifer7703

Joined
Jun 30, 2005
Messages
1
Reaction score
0
I am a beginning Access user and have built some data access pages for users to view and edit records one at a time. I would like to make some of the fields drop-down lists that call up values in a separate table than the database that the page is bound to, but store whatever value is selected to a field in the database that the page is bound to.

I'm using the NavwithServerFilterfromNumericField function that's in the sample Northwind database, and if I try to add a field that's bound to a table other than the page's bound table, the server filter breaks.

Does anyone have a solution to this?
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Learning Data Access Pages 8
SetValue for fields on a bound subform 1
Form filter combo box choices are Is Null/Is Not Null 13
Access SQL Lookup Function 5
Access 2003: populate combobox with CSV values from table column 1
Access Runtime - Inconsistant Saving 3
question on Access 2007 datasheet filter 1
Help using bound images in data access pages 1

Back
Top