ComboBox wont populate rest of fields in Form when viewing on Data Entry

[Zenobia]

Hello,

I wish to ask another question of you if i may. I have a combobox that is used to "find a value on a form" (created through wizard). Now with Data Entry mode off this works, changes and updates, however, with entry mode on (as i need it to be) it doesnt work..

Anyone have any ideas for me I'd be most grateful

 

[boblarson]

Of course it won't work with Data Entry set to YES. Data entry completely filters out all records EXCEPT the ones entered in the current session. So, you can't have the search for all records and data entry set to yes on the same form at the same time.

It will find any record that is entered during that session but no others.

 

[Zenobia]

What a shame, as it makes my return form look messy. Thanks again Bob, and thank you for helping me yesterday also

 

[boblarson]

You could use a button which changes it from data entry to regular for searching. For example, you could have a button that goes:

Private Sub CommandButtonNameHere_Click()
    If Me.CommandButtonNameHere.Caption = "Search" Then
       Me.DataEntry = False
       Me.CommandButtonNameHere.Caption = "Data Entry"
    Else
       Me.DataEntry = True
       Me.CommandButtonNameHere.Caption = "Search"
End Sub

And you set the initial caption of the button to "Search" and then the code would handle it. But would you want the user to be able to edit or add new records while in search mode?

 

[Zenobia]

Thank you! I'm trying not to make new posts if i don't have too.. So i would like to ask another question here if i may?
I am trying to make a msg box come up if the "Overdue?" Yes/No box is checked.. I have got this far:

IIf([ActualDateOfReturn]>[DueDate],True)

How do i format Then? I cant find any resources online to structure the display of msgboxs in an IIF statement.
I'm using Macros

 

[boblarson]

Your IIF isn't right, you should also include what if it is false. When do you want the message box to come up? Do you want it when the record is displayed? If so, then in the Form's ON CURRENT event you would put:

If Me!ActualDateOfReturn > Me!DueDate Then
   Me.YourCheckBoxNameHere = True
   MsgBox "Overdue", vbInformation
Else
   Me.YourCheckboxNameHere = False
End If

And if you are using the IIF for setting the control source of the checkbox then change the code to this:

If    Me.YourCheckBoxNameHere = True Then
   MsgBox "Overdue", vbInformation
End If

And you can shorten your checkbox IIF to this if it is the control source of the checkbox:

=([ActualDateOfReturn]>[DueDate])

as it will return true if it does and false if not.

 

[boblarson]

edited my above post - see the changes if you have already looked.