Search results

Sir, I wish you a happy life. I will help myself

If only you could finish what you started at this point, okay. If you can't, thank you. I will get to what I want

Sir, thank you for following up on my problem. I want to transfer the value of the testnameN field to the Fixedname field to be the field through which the listbox is filtered.

I want when I click into the field and after the listbox form opens, fixedname.value = Me.testnameN.value Filtering in the listbox is done based on this fixedname field As this pic MajP

Sorry, it's my mistake

I really want to learn, but now I am busy with my field in medical analysis. I am only making a system that enables me to work in my laboratory.

I called the function =FillUnboundControls([Form],"(Stool)",[color],[TestnameN],[Reportname],[Default],[Normal]) give me error

Just for your information, the value of the TestnameN field = the value of the Fixedname field. I want that when I open the form that contains the listbox, the listbox is not filtered based on the value of the Testname field, but the filtering is done based on the fixedname field, whose value...

Field values are replaced with each other

After trying the file, I think that there is a simple error, as the value of the Reportname field was replaced with the value of the Fixedname WHICH equal testnamen field. Is it possible to modify it for me?

Thanks

??

yes

Was it possible to add it to this part of the code? ' Function to update fields based on the active control's name Public Function UpdateFields(frm As Form, targetFieldName As String, fieldName As String) On Error GoTo ErrorHandler Dim db As DAO.Database Dim rs As DAO.Recordset...

in the Conditional formatting i put this control [state] Like "*L*" Or [state] Like "*H*" Or [state] Like "*low*" Or [state] Like "*High*" Or [Result] Like "*Equi*" Or [Result] Like "*Pos*" Or [Result] Like "*+*" Or [Result] Like "*>*" Or [Result] Like "*<*" Or [Result] Like "*Few*"

for example result of HCV Ab ( Positive 0.98 ) i need when i write positive, condition of field applied but when i write Negative 0.18 do no change for textbox

If I delete the value that I wrote in the text box, I want to change the status value to NULL

SO I DLEAT THIS FROM CODE

Else Me.State = Null MsgBox "Result must be numeric", vbInformation I NEED THIS textbox ACCEPT TEXT AND NUMBERS

I want these changes to occur while writing and not when leaving the field, exactly as in the picture