Use a parameterized view on CustID and set the NoDataOnLoad option. Then, when the user enters the customer ID, requery the view and refresh the form.
>I have a form that every time you start it it has values in the form that do not necessarly go together
>what I would like to know is how do I start my for "empty" "Blank" "no-data" and then be able to
>enter say the cust ID and get the info I want.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05