Wednesday, 18 September 2013

runtime error 3077 in ms access 2010

runtime error 3077 in ms access 2010

I have an access form called FindClientsListBox in which I am using a
listbox called lstbxClients to allow users to select which client's
information they want displayed on the form. lstbxClients is populated
with a row source property sql statement, and is not bound to data. But
the FindClientsListBox form is bound to data which, at the moment, is two
controls each bound to a field in a table called Clients. What I want is
for the values in the two controls (ClientNumber and FullName) on
FindClientsListBox form to change their values to match the client whose
name is selected in lstbxClients. But I am getting runtime error 3077 when
I select a client.
Here is how it looks when I click on one of the names in lstbxClients
(Notice that the name on right does not match the name on left, and that
an error dialog is thrown):

When I click the debug button on the error dialog, I am taken to the
following:

Can anyone show me how to get this to work?

No comments:

Post a Comment