Search results for query: *

YES, YES, YES, YES!!!!!!!!! That was it. I had always been told that if you really didn't need to use numbers (for math)in db, to use text insted which is what I did. Technically it is a "number" but I'm not doing any math with it. This is awsome for me. You have no idea.

pbaldy, I tried it but now it gives me runtime error2501. The OpenForm action was canceled. It is the right name. Does it matter that the ListOpen is based of a query? Once again, thank you.

i really dont know what I'm doing. I know bits and pieces from here and there. I have a listbox with 2 columns(Date, CallNumber). I want to double click on a record and have it open another form (frmEMCOpen) to the corresponding record (CallNumber). I modified the one you sent me and now it...

I tried it but it's giving me the following error: Undefined function '[CallNo]=[Forms]![frmMainViewEMC]![ListDone].[Column]' in expression.

Thanks for loooking. I am writing a macro that will open a form. Here is what part of the macro says: Forms![frmOpenEMC]![CallNo] = Forms![frmMainViewEMC]![ListOpen] I need it to open the first Column on that list. What am I missing???

Thanks for loooking. I am writing a macro that will open a form. Here is what part of the macro says: Forms![frmOpenEMC]![CallNo] = Forms![frmMainViewEMC]![ListOpen] I need it to open the first Column on that list. What am I missing??? Thanks again

Thanks a lot TheAceMan!! It works great. Now if I can double-click the record in the list box and have it open another form I'm set. Thanks again

First of all thanks for looking. I have a form with a field called CustomerName. On this form I have 3 list boxes (Open, Done, Closed) that look at query that points to the CustomerName field to display just the data that belongs to that client. When I open the form, the list boxes show the info...