How to clear fields if no match is found....

[TMD]

I have a database that holds service and repair details for PCs, the repair details are held on a repair table that is related by serial number to a device table in access2000. Currently my vb program shows the latest repair job for that device by using the following code:

dtaRepair.Recordset.FindLast ("SerialNumber = '" & txtPCserial.Text & "'&quot

this however, shows the last ever repair job in the access table for any devices that do not have a repair job created against its serial number.

any ideas how i can adapt the code so that the fields are blank if the serial number in the pc textbox - txtPCserial, is not matched to a serialnumber in the repair table.

Thanx in anticipation of your help.

 

[zemp]

Double post, see thread222-615763.

TMD check out faq222-2244 on how best to post and why double posts are frowned upon.

Thanks and Good Luck!

zemp

 

[jonathanmb]

Since responses to the question are already being posted in the other thread, here's the other thread: thread222-615763.

 

[jonathanmb]

Oops... looks like I'm a little slow to respond. Sorry about that.