Search results

There's something similar in the sample posted here (Thanks TechnoWeenie): http://www3.sympatico.ca/qaissuper/Index.html Download the SearchingOptions.zip and look at the code for "using a second form." It pulls up records with a match anywhere in the field, but you could change it to only...

I'll bet you could do it with the "OnChange" event of the master text box. Since the slave text box is on another form, you'll have to put in all the correct references, but something like this: Private Sub TextBox1_Change() OtherForm!TextBox2 = Me!TextBox1 End Sub Tell me if it works, Matt

Try this on the buttons: Private Sub FilterOnButton_Click() Me.FilterOn = True End Sub Private Sub FilterOffButton_Click() Me.FilterOn = False End Sub Matt

"AfterUpdate" is an event of your combobox (or any other control). Matt

OK, how about if the code is put into either the "afterupdate" event of the sum field itself (maybe when it calculates the sum that is considered an update), or into the "gotfocus" event of the first field of the form. Sometimes what I do is establish an entry control for the form, which does...

I have been trying to sort a subform, so your post caught my eye. It sounds like the query used to fill the subform is working correctly, but only once. Then it never updates itself. You might try a "requery" on the subform, and put it in the "afterupdate" event of the combo box. There are...

I have a form based on two tables: Tbl_Entity Entity_ID Entity_Type and various attribute fields Tbl_Event Event_ID Entity_ID Event_Date and event attributes. The two are joined one entity to many events through the Entity_ID field. The join works well, all associated events appear in the...

In reference to the latest runtime error: When I last received that error, it was because the combo box was returning the record ID instead of the associated name which I had in the code. Try inserting the hidden field from the combo box instead of the visible field. Matt

The same thing happened to me. I didn't end up using a subform, but had to be careful about just what was selected when I hit the "paste" button. I forget the exact order of events. I think that the tab control had to be moved to the front, then I selected a particular page instead of the tab...

You could use an event, like "lostfocus" for the subform, or "oncurrent" for the main form; then write a simple "IF" statement to assign the "Fore Color" property of the control that presents your subform sum. Private Sub Form_Current() If Me!RequisitionSum >= Me!ReceiptSum Then...

Are the record navigation controls still functional? If so, you should still be able to navigate to previous records and edit. Now all you need is the combo box: there's a wizard which searches for the record based on the info you select (name, zip code, whatever). Matt

What is meant by reinforcing relationships? I've been working with some multiple table joins and this is of interest to me, too. Matt

I think the way to do it in a relational database is to leave the information in the customer table. On your "complaint" form, create a "customer" combo box that will use a lookup: you select the name, and the box returns the customer ID. If you attach the related fields from the customer...