Search results for query: *

right ... label name and textbox name If you have only 2 or 3 labels, write a line for each; if many, you could use TAG property and write a little SUB to change all those with a given TAG Bob

I do this ... In the OnCurrent event of the form and in the AfterUpdate event of the textbox, put Me![Label].BackColor = IIf(IsNull(Me![textbox]), 255, 16777215) Bob

I think this is what you are looking for-- In form Design View, click on the tab with the listbox (it should show up in the property sheet as a 'Page'). In its OnClick event procedure, put me!WhateverIsTheListboxName.SetFocus me!WhateverIsTheListboxName.Requery Bob

...and what I'm trying to do is post in my sleep. Here's the rest of it. Put combo270 in the header of the form that you want to use to edit your data. Click on its EVENTS tab and put [Event Procedure] on the AfterUpdate line and click the button with 3 dots. Paste in the sample code that...

I think you are trying to do this -- Private Sub combo270_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[propertyNo] = " & Chr(34) & Me![combo270] & Chr(34) Me.Bookmark = rs.Bookmark Set rs = Nothing End Sub Bob

try it with an apostrophe (') before me.visible =false in SeeThru's code Bob

Quotation marks (single and double) are tricky. You have Me.Filter = "Project = "" & Forms!ProjectSub!Project & """ Try Me.Filter = "Project = " & "'" & Forms!ProjectSub!Project & "'" w17

Mailing labels will likely use Trim()... each line would be a TextBox with a Control Source like: =Trim([Firstname] & " " & [Lastname]) If you are missing the arguments -- the stuff in () --it would be treated as a Parameter... walkinman17