Find a record by entering number in a text / combobox

[eireguy]

Hi everyone,

I have a business repairing electronic items for the entertainment industry,please forgive me for asking what must be such a simple question, but I can't seem to get this to work.



I have a form which shows customer information and a subform showing repair details for that customer, all based on underlying tables. So customer 100 might have 6 repairs, customer 200 might have 3 repairs etc.

I would like to have a text or combo box into which I can enter a repair ID number and press "enter" on the keyboard to find the record associated with it, in other words the result would go to the corresponding form / subform. The box can be on the repair details subform or on the customers form if that makes any difference.

I hope I have made myself clear and if you need further info please let me know, thanks v. much in advance for whatever help you can give me, regards, John.

[orange]

John,

Here's a short video by Steve Bishop on subform filtering that shows a technique that you may be able to use.
Good luck.

[ranman256]

the tCust table:
CustID (auto)
FirstN
LastN, etc..

the tCustRepair (sub table)
RepairID (auto)
CustID (long)
InDate
OutDate
RepairDescr....etc

the master form would show 1 record of the Customer
the subform would connect to the tCustRepair table
the PROPERY of the subform would be bound to the CustID:
LINK MASTER FIELD: CustID

LINK CHILD FIELD: CustID

then all data you enter in the subform will auto fill the tCustRepair.CustID

in a form that shows ALL records,
an unbound box to enter the search term:

sub txtFind_Afterupdate()
If IsNull(txtFind) Then
   Me.FilterOn = False
Else
   'Me.Filter = "[ItemName] like '*" & me.txtFind & "*'"
   Me.Filter = "[ItemName] = '" & me.txtFind & "'"
   Me.FilterOn = True
End If
end sub

then open that record:
docmd.openform "fMasterForm",,,"[ClientID]=" & txtID

[Bob Fitz]

John

I've attached a very simple db that does what I think you require.
Use the "Find JobID" combo box in the Header section.
Post back if it is the kind of thing that you want and you need any help to implement it in your own db.

[eireguy]

Thanks very much for that, I appreciate the suggestion and I'll try it and let you know, best regards John.

[eireguy]

Cheers Bob, I'll try that, much appreciated, regards, John

[eireguy]

Appreciate that Ranman, I'll give it a go and let you know, stay safe and best regards John

[eireguy]

Hi again guys,

This seems to be a blind spot for me, I designed the DB about 10 years ago but I seem to have misplaced the knowledge I had to make it, hence the question ! Maybe if I state the problem in more simple terms ?

I want to;

1) Add a text or combobox to a subform.
2) Enter a number in one of those.
3) Display the repair ID that matches that number. The subform has a field based on a table named "repair id"
4) Thats it !!

Please make allowances for me, I'm not even a novice at this stage and VBA is (generally) beyond my talents.

Many thanks to you all,

Regards and stay well and safe, John