Recent content by rzw0wr

I have been looking for the answer to this question for several months. I should have known I would find it here. This program works great. Thank you, Dale

No. Relate the table KPI to the employee table. Dale

I would try a combo box with the team Names. A subform with the data needed. Relate the 2 form with the team ID. Dale

Sounds to me that the database is about employees. KPI is an attribute of employee and reporting time is an attribute of KPI. Employee 1 to many KPI 1 to man Reporting time. Just my thoughts. Dale

I stay away from Nav forms. I have never figured them out. Dale

Try making a field, Sur_Defi:Auth-Held. Just a guess. Dale

I had a problem trying to type in the editor after opening the frmPasswordScreen. It would NOT let you type a space. Could not type in commands. Strange. Dale Note: It appears to be the timer Event. Since the form does not close the timer continues to run.

How do you open this file? Dale

No I don't mind. Dale

I found a few places in your form code where you open a DAO recordset several times but only close it once. You use the same name and I don't know if that will reopen the same recordset or open another with the same name. You may want to look at your code to make sure you close each instance...

If I am understanding correctly. Access does not know what to display until you select something from the combo box. After selecting something in the combo box the data should display correctly but not before. Dale

for text box. =comboboxName.column(Number of the data column you want to show -1) The combo box holds something like, combobox.column(0) = ID: combobox.Column(1) = Text: Combobox.Column(2)= Text. Unless I don't understand your question. Dale

for text box. =comboboxName.column(Number of the data column you want to show -1) Combo boxes number starts at 0 not 1. Dale

2010. 32 bit.

Hmmm. In the After Update event of the first textbox you add data to, Type forms!form4a.refresh. Dale