Replies

I checked the “Hide Duplicates” property before I posted my SOS. Also, the lastname control is not on my report. What is on my report is the concatenation of the lastname and firstname.

When you say “dummy” group level I’m unsure what that would be.

Creating individual reports then adding these reports as subreports to a blank report for the most part works however am issues w/ getting columns heading to appropriately appear on each page of the subreports.

#164 worked.

Compact and Repair does not help. I will create a new database and import. However, it is really strange that when I show direct relatonships and show all relationships there are no relationships. Yet when I go to print the relationships and get the print preview I can clearly see that there is a relationship between a table and a lookup table.

Nor is it allowing me to simply delete this field. Am I stuck w/ this field forever?

It seems easiest for you to say than a novice like to do.

In form design view I deleted the current combo box. In my toolbox I turned on the Wizard Controls; selected combo box and placed on my form; indicated that “I want the combo box to look up the values in a table or query”; selected my tblEmployee (containing EmployeeId and Employee fields); indicated the Employee field to be included in my combo box; selected ascending sort order on Employee; indicated for the wizard to store that value in the Employee field.

I left the Control Source blank as previously suggested. However, I am still getting an Enter Parameter Value message.

Edited by HansV to replace PDF attachment with the screenshot it contained

I have made the combo box unbound and I remove the navigation bar from the main form. When I tried to select a name from the combo I received the attached message to enter a parameter value. I don’t see what would trigger this? Thanks for any directions!!

If the Employee name is being selected from the combo box then I don’t see where the navigation bar serves a purpose on the main form. Thanks for your help!!!

Is there any reason to have a navigation bar at the bottom of the form since the combo box is what should be used? Can / should I hide the navigation bar for the main form?

Then how do I select which employee that I want to work with – select from the combo box at the top of my form? If so, then obviously I don’t have something set up quite right for when I attempt to select the employee name from the combo box I get the error message “Control can’t be edited; it’s bound to AutoNumber field ‘EmployeeID”

Thanks!!.

This is supposed to be the main form which is how I select which employee I want to enter visits for. And, the subform is used to enter the visits for the employee.

Thanks!!!

What does the ampersand lt in the validation rule you shared rule mean? I enterred and tested it. However, when I tried to correct the date Icontinue to get the same error message.

1) See attached. It appears I kept getting the indexing error message because it was recycling the VisitID (19150 – 19161). Each time I got the error message I would exit the database and then go back in. When I tried again it would recycle the next VisitID number even though it is supposed to be unique and an autonumber.

Once I got pass VisitID 19161 I didn’t get the message again.

Any ideas as to why did a field w/ data type of autonumber recycle the autonumber especially when it is the primary key?

2) In trying to figure out the indexing issue I notice that someone in erroy has input future dates ( 08/08/08 and 05/08/09) as the date of visit. How do I check this upon input and flash an error message to person keying in the data?

Attached is what I’m finding.