I have have query which has a parameters from from that is working fine. The problem arise when i run a cross tab query from this query. The error show is microsoft jet database engine does not recognize forms!formname!field name as a valid fiedl name or expression. I check that query but...
Lookup Field
Check the combo box property
In row source give query lik
select customer_name, customer_id from customer table
in property bound column give 2
now in form it will show the customer name but store value customer_id in the table when you save .
If i mis-understand accept my...