Search results for query: *

I set the break points, the code is not executed and I got the same message, but this time the message appeared when I hit the enter key. key Preview is set to yes in the main form.

no, it doesn't stop, it goes right through.

I did removed the KeyDown code, and I have not been able to find anything about the ActiveX control.

FOLLOW UP is the mainform, and I have a tab control with FUpIssues subform in the first page and SWHealthEducation in the second page. Another important thing that I forgot to mention before is that the data entry rutine would be as follows. From Mainform (FOLLOW UP) moves to Subform1...

This is the code in subform2, after I set up the KeyPreview to yes. Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Call SubFocus(Shift, "FUpIssues") End Sub This is the code in the module Public Sub SubFocus(Shift As Integer, curForm As String) Dim frm As Form, sfrm1...

Hi AceMan1, I tried your suggestion, but as soon as I hit the Ctrl key I get the same message I mentioned above. Any ideas what can be causing that?

Sorry to come back here for more help, but I am stuck now in another step of building these forms. What I am trying to do now is to move from the first subform in the Tab Control to the second subform also in the tab control. I set up the code based on suggestions given here for my previous...

Thank you very much AceMan1, that worked perfectly.

Hi AceMan1, thank you for your idea, I tried it but it is not working, here is what I put in the code, may you can help me figure out what I am doing wrong. Thank you Private Sub DateofTransfer_AfterUpdate() Forms![FOLLOW UP].SetFocus DoCmd.RunCommand acCmdRecordsGoToNew...

Hello, I have a problem about returning to related froms. I have a form that opens another form with a command button, what I need to do after entering data in the second form is to return to the first form with either the return key or tab key to start a new record in form 1 and repeat the...

I am very new to Access, could you be a little more specific about the Master/Child links properties? Thanks

I have four related tables and all have a field "PATIENTID, how can I update this information in all the tables using a form and sub-forms without having to type the info in each table? the patient ID is a text field with alphanumeric characters.

Thank you Richard for your ideas and recomendations, your help was very valuable. Thanks to every body else too for all the suggestions.

Thank you Richard, I think this captures exactly what I need, although I still have a question about the QuestionID in the tblPossibleAnswers, I have a total of 55 questions, but the set of answers is always the same for all the questions, so in this case would I need to type all the 55...

There are about 50 questions and 5 possible answers, all the 50 questions are answered during the same interview, but each question gets only one answer, although the same question will be asked again at a later time.

Sorry, if I am a little confused, but Wouldn't table three store the question ID and the answer to that specific question?

To make sure I am in the right path, is this what I would end up with? Question Table Question QuestionID 'Depressed', '1' Answer Table - List of Answers to the Question AnswerID Answer '1', 'Acute' '2', 'Mild' '3', 'None' *Third table*? Data Table - Holds the answers given by the surveyed...

Refering to the second table "Answer table" wouldn't I Need a field AnswerID and not Question ID?

One more question, do I need to keep the field QuestionID in the Answer Table?

Thank you, I think this is what I needed.