It should have worked. Try Forms!Form1! instead of the word Me "ashfire" wrote: thanks for the help but when i paste it in i get The Object doesnt...

I have a text box on my form and I keep getting the above error I understand why I am getting this and that is not a problem, I just need to stop it from...

thanks for the help but when i paste it in i get The Object doesnt contain the Automation object 'Me.' "Dennis" wrote: the control source property of...

the control source property of your text6 box should look like this =DLookUp("","Compt Info"," = '" & Me. & "'") "ashfire" wrote: I have a form (Form1)...

Hi Sam The way that i would have done it is to click on the query and then go to the button that is a box with lightening through, choose the form option...

I have a form (Form1) and i have a combobox (Compt Number). When i select from this combobox i would like to populate a text box (text6) on the same form,...

We are trying to use disconnected ADO recordsets with Access forms and having problems. If we disconnect the recordset, change it in code (no forms...

Is it possible to create a simple command button that will change the underlying query of a forms record source. E.g. click on the button and display all...

How do I encrypt and decrypt a string in Access97? What are my options?

Hi Guys I'd be so grateful if anyone can help me with this problem. I am really really struggling with this and need to get it sorted if i can. Here's a...

I want to display a total number of records where a field matches certain criteria next to the (record "current record" of "total records) on the navigation...

I have a table in SQL, that I know how to connect to using ADO, but I need help on how to read records from that table. So on a form I have a listbox where I...

I have a Table for Job and a Table for Transactions, I enter daily Transactions and debit employee time to the Jobs which are on hand. I want to display only...

I have a report that runs from a prompt form that has two controls for date parameters. The report runs fine on my machine but when another user tries to run...

I have an Access DB that prints an Report using data in a table, then have an image (.TIFF) that is printed behind it using the location on our server. (i.e....

I have been unsuccessful at getting the Child Fields in subform records to relate to the Master Fields. What I'm trying to do may be a bit different, so I'll...

Hi I have a list of all activeX controls registered on my system. When i add one of these activeX controls to Windows Form on runtime , an exception is thrown...

I have an uneasy feeling here..... I am using a form to create a date range for an Access report. When I run the report, I enter the dates, then press my OK...

I have a form that contains a subform. The main form contains the Primary (parent) business information, and the subform contains the Secondary (child)...

Hi, Have a simple form that includes a subform. In the master form I used the wizard to create buttons for next, previous, first record, last record, add...