Search results

So you need to be able to search the report? You can search the report with Ctrl+F although it is not elegant. The other option is to create a link from your form that opens up your report to the specific employee. You could also probably create a pop-up search form to search the report...

Sorry I disappeared: I went away for a long weekend. I will take a look at this and get back to you. You probably just need a simple query to present the data the way you want to present it.

No offense, but this seems like a very odd way to do this. Perhaps work on making the database more of a relational database and less of a big spreadsheet. If you work on the data structure, I bet you will find there is an easier way to present your information without relying on so much code...

There is a lot more involved here than you initially let on. I cannot read it all right now have to get to a meeting. Maybe post a more specific question in the VBA section of the forum.

Ok, well it is hard to give suggestions without an understanding of your data structure. I am assuming you tried this already but you may be able to filter the forms in the WHERE clause of the DoCmd.OpenForm

If you do end up decompiling, save a copy of your database first. If you just compile in the code window (ALT+F11) you need not save a copy.

Yes, go into the code window and compile and see if any errors appear. However, if the issue crops up again and you have searched high and low for a cause and none is found, you also may need to decompile your database...

Select them all first--you can click outside and drag around them all to do this. Then make headers by using Group. It takes a little practice to get used to report formatting but you will get the hang of it.

Right click on the controls and select "Layout>Remove" Then you should be able to move them around

I think what you want to do is make "cascading combo boxes". Search for that term and if you have trouble post back with your specific problem. Good luck!

Great! Let me know if you need help with the subform and the report. If you use the wizard for the subform it should pick out the correct fields to link since this is a straightforward situation.

Ha ha, ok.

I am still stuck on this :banghead: I have checked the subform separately and it does not have the issue. It remains dirty (i.e. it does not save the second after the first field is updated and it is possible to undo selections). I even inserted the subform into another form just to make sure...

Okay but it still sounds like there is something going on and that the issue may crop up again. You may want to make a copy and decompile your database

By the way, based on the content of the error message it sounds like the problem is on the OnLoad and that you may have left out Private Sub (or another identifier for the procedure) but sometimes these error messages say one thing and the error is really somewhere else...

Not a genius but you should go into your code and try to decompile (Alt+f11 then Debug>Decompile). It sounds like a problem with your code.

Drag the field onto the matching field and select enforce referential integrity

BTW, the relationship between tblEmployees and tblTests is one to many (one employee many tests). Make your relationships in the relationships windows (database tools>relationships). In your table, the FK fields should be a NUMBER datatype with no lookups. Lookups will go in the forms.

Hi, I will try to help you. Even if Employee ID is a unique field, I wouldn't link the tables by that. You should set up your tables with an AutoNumber field and use that as the Primary Key. Then your table structure will look like this: tblEmployees EmployeeID (PK) CompanyEmployeeID Sex...

And you can make it modal even if it is not a pop-up. That is what I do.