Search results

The problem is the type of relationships that you applied to the tables in the query. Try changing the join types and this should fix your problem.

I have two combo boxes on one form. I want the second combo box to only show related records depending on what is chosen from the first combobox. Any help on how to do this? Thanks for your help in advance. BAC

Thanks RHicks. Worked like a charm. BAC

I have a combo box [drugtype] that had (3) columns. On the same form I have a regular currency field that I would to auto populate with the value of the third column of the combo box [drugtype] when the field in [drugtype] cbo box is chosen. Please help. BAC

thanks e_kimball. Worked.

Is there a way that I can have the current user shown on the form in a unbound field? If so, how? Thanks.

Sure is.....just create two unbound fields in your report header ...one for beginning date and one for ending date. then in the control source of both field put in the exact parameter criteria that you put in the query. For example, in the criteria of the query you have >=[Beginning Date]...

I have a form that shows the results based on a select query. I would like to put a command button so that a report would print based on the information on the form. I've created a report based on the same query that the form is based on. However I need the report to be able to be accessed...

Thank for your response Rich....I am 99% with you but still a little confused. I have a department combo box on a parent form with (3) department names for the user to select. When a certain department is selected....say "Payroll" I would like for (2) fields on a subform to be visible for...

How would I make a field on a subform visible by what is selected in a combo box on the parent form? Any help is greatly appreciated.

Thanks Travis......Right on both questions. U The Man.

How can I sort the results of a combo box alphabetically? Also how can I filter out certain records in a combo box by populated field. IE Say I want a combo box to show every record in a table that had the date field empty. Thanks for all your help out there.

You need to create a query with the two tables that you want to display in your form. After creating the query, create a foem based on that query and then insert your combobox. This should solve your problems.

How come when I use the ">" symbol in the format section of a field's properties to capitalize all the text, this limits the number of characters I can type into the field?

Thanks Neal, I did change it to input the criteria from the form. I was just curious if there was a way to show the parameter query in a from. Thanks for your response.

You can set up a Requery macro that attches to the beforeupdate control in the properties option. This should fix your problem.

I am getting the parameter value from the criteria in a query. Under the date field on a query in the criteria I have "Between [Enter Beginning Date] And [Enter Ending Date]". I would like to show those two dates in two unbound fields on a form. Thanks for your help.

Any Help Please???

I created a subform on a subform and when i open the main form a parameter error is looking for a key field on the first subform. If I delete the second subform and open the main form I do not get the parameter error box. However the second subform needs to be linked to the first subform...

I know that a query parameter criteria can be displayed on a report, (i.e. Date range "from" "to")but can this same type of information be diaplayed on a forms unbound field? I tried it and it didn't work. Thanks for any help.