This code i confusing

[Lou_Reed]

In the attached zipped db is the frmPersonnel. Now what is going on after I select a name say "Dwight Frye" and move into Sub Combo170DblClick.



I see no variable with that name attached to it.

If I did I would use it in the next Sub txtRemovePersonnel-Cick(0.

I selected Dwight Frye and i would like to use that name in the seconf Sub where I would remove that employee.

Any help appreciate. Thanks in advance.

R,

Lou Reed

[Bulzie]

Lou I think that code caused the Eclipse today

Lou search online for docmd.searchforrecord and it will show you what those arguments mean. Basically looks like it is selecting a record based on the PersonnelID of the record you are actively on. Then maybe calls function or module called updatebuttons? Then beeps at you and gives you a message?

[Lou_Reed]

You are correct thanks for pointing this out to me. It has been awhile since I worked with records and that is why I did not recognize them straight away.

Thanks for your help.

Respectfully,

Lou Reed

[Lou_Reed]

Also a few pointers here. In a reference to a table the first column is 0 or 1?

It would help to know.

Respectfully,

Lou Reed

[Lou_Reed]

Then beeps at you and gives you a message?

Yes, what is this message all about? It seems to be seeking a response from the user, but why?

If you choose the name that should be it.

I have the macro "code" and can post it if needed.

Respectfully,

Lou Reed

[Lou_Reed]

I really need an answer to this. I am unsure as to what the purpose of the message that
comes after the beep.

I believe that it is not working correctly.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

Lou I think that code caused the Eclipse today

Lou search online for docmd.searchforrecord and it will show you what those arguments mean. Basically looks like it is selecting a record based on the PersonnelID of the record you are actively on. Then maybe calls function or module called updatebuttons? Then beeps at you and gives you a message?

Yes, but what is the message? I click OK on the dialog window that pops up, but it seems to just rash the program.

Respectfully,

Lou Reed

[John_G]

The message box is actually showing nothing meaningful, as the MsgBox statement is not written correctly. The entire message is inside quotation marks, which means that all Access does is parrot that (not very useful) information back to you. You can delete the MsgBox line with no harm done.

If there are issues that arise after you clear the message box, the message has nothing to do with it.

[Lou_Reed]

I thought so. But it seems to have Sub or something like it, that branches off when it believes an error has occurred.

So if I delete it will I be in blissful ignorance?

It does not generate the error for nothing or does it?

Respectfully,

Lou Reed