Search results

To the best of my knowledge yes. I just would have a search or "filter" combo box. That way they just type in the name of the project and it will pull up the one that they want. After that the Task subform will update to the perticular project that was selected. I hope this is what your wanting.

There are thousands of Customers and one image for each Customer

First, thanks for your responce. So your saying that there is no way to Filter the AccountNumber.Value or AccountNumber.Text to find the image you are looking for. Something like setting it up to where it looks for it in a certain folder like (C:\dbimages) and then has the criteria of the text...

If so, use a combo box with the control source of your project table. Have the combo box lookup the project you want.

Is the filter for a certain project you want to find?

Is it possible to have a cmdButton open a pre saved image from your hard drive. The images are saved with the same name as the Account Number. (ex: AcctNum -- TA123409 Image -- TA123409.bmp) I want the cmdButton to open the image filtered or based on the Account Number. If so, could someone...

Thanks for the reply. In a way I'm glad it wasn't only me.

I have an a2k db, recently I installed office 2003. On one of my forms I use the mousemove event to change the color of certain text. This works fine on office 2000 platform, but on 2003 it makes everything flicker real bad. Does anyone know what the cause of this could be.

This is what I tried on the OnClick of the cmdButton: 'Me!frmPartsSelectionSub.Form!CustomerID.Value = Me.txtCustomerIDMain.Text

I don't think that I can link the main to the sub because of the way the info is gathered. You said.... Fill the variable with the "current" CustomerID and seed it into the control on your subform. Please give me an example of how you would do this.

You'll have to forgive me I kinda new at this. I have a form with a non linked subform on it. The main form has one control on it called CustomerID, the subform's record source is from a select query that is updated by a cmdButton on the main form. The cmdButton runs an update query. One of the...