Data Entry Form "Yes" and "No" . . . can I have both?

[buckwheat]

My master form's source is a query. I have a cbo box and four fields from another query. I have a subform that returns data entered to a table for report purposes. The subform needs to be set as data entry so history is not visible and cannot be changed and only "new" data is permitted.



My problem . . . if I select Data Entry for the main form . . . no other fields populate in the four fields I have to confirm employee details, if I select No for data entry, then previous data is visible on the subform. . . Is there any way to have both options for data entry . . . meaning "No" on the data entry and "Yes" on the subform?

The other issue I am having is when opening the form . . . . there is "0," when selecting a name, nothing appears in the cbo after the selection . . even the primary key.

[RuralGuy]

You should be able to set the Form that is displayed in the SubFormControl to DataEntry without affecting the MasterForm.

[buckwheat]

hmmm . . . makes sense to me too, but when I set the sub to "Yes" data entry and the master form to "No," the "yes" seems to be ignored. Do you have any suggestion as to why I would be getting a "0" in the cbo box after making a selection instead of the primary key (emp #)?

[buckwheat]

I think I've solved the "0" issue. As far as the data entry . . . I'll just create two separate forms . . . can't spend too much time resolving the problem. Thanks for your help.

[buckwheat]

Nuts! . . . it didn't work. Here is my code for the "0" in the cbo issue. How can I modify so the emp# appears in the dropdown after making a selection? Many thanks.

Private Sub cboEmployee_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Emp#] = '" & Str(Nz(Me![cboEmployee], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

Me.Compensation_Worksheet.Visible = True
End Sub

[RuralGuy]

A cbo displays the Bound column of the cbo?

[buckwheat]

if you're asking if the cbo is bound, yes to column 1 = Emp# (primary key)

[RuralGuy]

To what do you have the Column Widths and the Column Count set?

[buckwheat]

column count = 3 (emp#, last name, first name), width = .5, 1,1

[RuralGuy]

What actually appears in the dropdown after making a selection?