Recent content by DougW

Geoff, Thanks for the input. What I finally did, after attending about 2 days in "flounder" school was assign the phone nr. to a variable from the customer Info from. Then opened the SoldInfo form and inserted the number in the phone field of that form. The reason I did this is because I am...

I'll try to be as brief as possible. I have a form "CustomerInfo" which includes the customers phone number. I have a button on this form called "Sell". When the "Sell" button is clicked on I want to capture the phone number from this form, save the current record, and close the form. Then...

Is there a way to execute a function from a command buttons "OnClick" property without calling it from a macro? Thanks, DougW

I searched this site and found the answer. I needed to add Microsoft DAO 3.6 Object Library to my references and that solved this problem. I suspect as I move along through this project more will be sure to appear!!!!!! Doug W.

Jim.... Thanks for the reply. I tried what you recommended and alais it did not work either. I am trying to do this in the body of a function. Is there possibly something I need to add to the general declarations that I'm forgetting? Thanks, Doug W.

My how things have changed...... Trying to do a simple Dim statment to define a database prior to setting to currentdb. But, I keep getting error "user defined type not defined"... All the samples n' such show the use of "Dim db as database" but it's not working for me. I even cut and past some...