Recent content by grane236

Hi pbaldy, its 7mg so I dont think so unfortunatley. stece

HI pbaldy, I tried this and still get the data type conversion error or another error With Me.RecordsetClone .AddNew ![Contact Name] = Me.Contact_Name Me.Contact_Name.ForeColor = vbRed ![Position Title] = Me.Position_Title...

Thanks pbaldy. I now believe its becuase they are not text fields. I need to refer to them differently. Most are combo boxes or list boxes. Any advice? Thankyou.

HI, Im using this code to copy fields from the previous record in my form and put the copies field values into a new record on the form. HOwever the code doesnt work when it tries to find the previous values for any fields on a tab page other than the first one. I tried to change the focus to...

The combobox retrieves the right text (if I hover over it in VBA it shows me the combobox135= "Roddick Enterprises"for example). I think its finding the business name in the table to compare it to which isnt working. I should mention my form has fields from two tables. Im only trying to return...

HI Isskint, The combobox returns the name of the business. I do have a matching field type for business name (text field) in my form, but all im doing is copying what was selected in the drop down to this text field.

The Combobox is simply bound to the field Business Name in the table Business Details. I tried using an unbound combo box but still had no luck.

Thankyou Isskint, But I still dont retrieve my record regardless of whether an existing business is chosen. Perhaps I need to identify my table first for my business name field?

Could someone please tell me what Im doing wrong? I want to retrieve a record from my table (business details) based on the business selected in a drop down. But my code says its a new business every time, regardless of whether an existing business is chosen from the drop down: Private Sub...

Hi, I have a form which has fields connected to two tables. I have a drop down which should return all fields from one table when an item is selected from the drop down It worked in another form where I just had a text field but now I cannot get it to work with my dropdown. Any advice...

Thanks John, I did see this as an alternative method however having about 20 fields to autopopulate I figured it wasnt the best way to do it. I simply want all the records from Table one based on the selected item from my combobox. Simply not proving to be the right word.

Hello, I have read about 2 dozen posts on this and it appears simple. Yet my code fails every time. I have 2 tables with data. I have a form with multiple tab pages. The controls on the first tab page all come from the first table. I have a drop down "Choose or Enter Business Name" which...

Thanks Isskint, You were right. My code now works on any page after I focus o it. I just need to loop my code through each page. I imagine this is easy but if you have any advice on how to do it I would be grateful. focus on page 1 Forms![Auditor Assessment Form].TabCtl0.Pages(1).SetFocus...

Hi Isskint, Thankyou for your reference. I can see how to reference other pages but my attempt to incorporate it into a clear controls request failed miserably. Any advice? Thankyou. Dim ctl As Control<LI class=L4><LI class=L5> For Each ctl In Forms![Auditor Assessment Form]![Assessment...

I have a clear (reset) controls button on each of my tab pages which clears all the controls in the subform on that page. However I would like to have just one button which clears all controls on all forms on all tab pages. Is this possible? I have a save button which resides outside the...