Search results

This is a good one. If you ever see it don't expect the displayed message to be of any help what so ever. I had a form with two sub forms. The Parent and both Children each had link fields called "Task_ID". Task_ID was used on subform properties Parent and Child. I also had a Command Button to...

Here try the following. Other than spaces it should work just fine. Cheers ' Start Code Private Sub File_Click() On Error GoTo Err_File_Click ' This works if called from a form which has the value displayed that you want to print. Dim xdir xdir = "C:\My Documents\" Dim xname xname =...

Try using a Form / Subform combo. On the parent have a single unbound combo box for the user to select from. Have the data in the subform linked to the value in the unbound combo. The source for the subform should be limited to the value in the unbound combo. Hint: In query criteria -...

Yes, but why whould you want to store duplicative data? If you are populating the combo box from a table source then why not put a unique identifier on the source and store that number in you other table. The first rule of data normalization is to eliminate duplicates. (Hint: use a dlookup...

While using queries works, it is a whole lot easier to debug later if you convert the query to SQL (From the query designer) and paste it in your data source. This works for all but the most complex queries. Remember to limit the data to only what you need and to name your queries properly...

Macros are slower by nature and add additional objects to your database. Suggest you use a DoCmd.

A sub form, by nature and design, is limited to the Parent record relationship. In order to search thru all subform records you should create another form (called from a command button) from the Parent form. It will open the form that has all of the subform records (Child) that can then be...

You need to use the Set Filter option. The easiest way to do it is to create a macro with the Open Form command. In the filter box enter "[Project Number] = [Forms]![Form1]![Project Number]. Of course, this is a little kludgey since you end up with a macro. To see a better way - convert the...