Search results

I am updating records in a file by adding using recordset VBA code. These are displayed in a subform. I have tried all different combinations of requery without much success.... I know I just don't grasp the concept. Help. I am using Forms!myformname.requery It usually comes with an error...

thanks.... I will try this...

thanks for your help and advice. I found my problem. I had mistakening 'linked' a field that was wrong. I still struggle with knowing when to use . [] or !. I read the knowledge base info, but still find it confusing... thanks.... Ken

I am having difficulty updating records since I referentially linked a field. The following code was working fine and allowing me to add records. Since I linked the ProbNum field in 2 tables, I am now getting an error that states "you cannot add a record or change a record because a related...

Private Sub Form_Current() intField2 = [ProbNum] 'sets current probnum to a variable - function Debug.Print "this is ProbNum on current form", intProbNum Forms![frmPatGoalTx].Requery End Sub the form name is frmPatGoalTx. It is already open. when I use the above code...

no link I do not have a link. The only "link" is that the other form is based on a query using functions from the main form. I have tried using the requery and it does not update the form. The only way it seems I get refresh the form is to close it and then reopen it. There must be a better...

I have 2 open forms that are connected by a query and not a parent child type relationship. that is the values from fields on first form are used via functions to create a query which is the basis of the second form. I would like it to behave similar to how a subform works, that as it updates...

think I figured it out I read that a query cannot accept a "value" but it can accept a function. I made a global function and my problem seems to be resolved... thanks

still trying I was trying to use a value of a number field from a subform, 'store it' somehow as a variable that was referred to in a query, then run the query (all automatically). I am struggling with where data is 'kept' and how to recall and use it. I had tried to save the value as an...

How do I store a value of a number field from a selected record, to use in a query later?

only one field I have a subform related to a main form (patient info). The subform scrolls through a list of problems that a patient has and is linked to the main patient info form. What I want to do is to be able to scroll through the problems and have it list the available goals for each...

same field Example: As I place the cursor on a given record in the Form, I want to have it change the Query value - always in the same field......

I have a form the displays several rows of a file. When I select a row, I want it to be able to pass the value of one of the fields of the selected row and use that as the criteria in a query and then open the query. How do I do this?

thanks thanks for the examples...

I am new to VBA. I am developing a program to input problems and goals on patients. The patient may have multiple problems. Also the problems may have hundreds of variations. So I have used a combobox to add the actual values stored in the problem field. This part is working well. Each problem...

thanks great....thanks....

how do I do that? thanks but how do I do that?

No Well I appreciate your input.... but it is not the correct solution. I am very familiar with data base design and the avoidance of redundancy. However, this was not the question that I asked. Since the patient problems have thousands of variations, I only wanted to copy problem fields...

I am writing what I thought was a simple Patient form to enter new problems for a patient. A patient may have multiple problems. I want to add problems quickly from a pre-defined list of problems. I have a Patient File which is linked to a Patient Problem file. I also have a Problem List file...

I am writing what I thought was a simple Patient form to enter new problems for a patient. A patient may have multiple problems. I want to add problems quickly from a pre-defined list of problems. I have a Patient File which is linked to a Patient Problem file. I also have a Problem List file...