Search results

Got it. Sometimes I try and overthink these things... never a good idea. I just get myself in more trouble! I created the unbound form, simply a combo box referencing the list I want to choose from. I then created the query I will use to select data from the table I'm pulling info from. In...

Hey ScottGem, Thanks for the help. This should work perfectly. The only question I have is, what is the "controlname" referencing? Thanks again, John

I'm trying to create a report that is generated from a query. When I open the report, I would like the opportunity to refine the search based on a list of sales people. That is, I would like a drop down box with selection criteria (from an existing table) to pop up when the report is opened...

Can anybody help me link a column in the bound table with a text box in my form? The problem I'm encountering is, I use the control source to define the formula, so I can't include the column name of the bound table. Help!!!

If the information does change, I'll definitely have some issues to work out! Is there a way to tag the control source line with the name of the column in the bound table and the formula? I thought I could do something like this -> LineOfBusiness: =DLookUp("[LineOfBus]","[LineDetail]","[Item]...

Hey ghudson - I see what you're saying, that makes sense. However, one of the "calculations" is simply to add a summary notation based on another entry. For instance, the user identifies a line of business as golf balls, I want to add a summary to the table that notes this entry as golf. I...

I have a form where users enter data in various ways - combo boxes with drop down selections and text boxes where users manually enter some data. I also have several text boxes that return "answers" based on calculations from user entries mentioned above. The form is bound to a table where all...

Thanks applevacross! That worked like a charm!!!!

The combo and text boxes are bound to another table where information will be stored. Is there a way to do this with a bound table?

I've developed a form where users enter and select information that will be stored in another table. Currently when I open the form, the information I entered from the previous use is still in the text and combo boxes. Is there a way to clear this information when the form is opened (so all...