Search results

@theDBguy... You are right, as if I have to tell you that! The text box being used in the database I was shown only calls up record information from a db record, it does not search and bring up a valid, existing recordset. And I spoke with the user and helped them understand just what was...

@theDBguy... Yes, that worked. Thank you. Back to the development... That is what I was trying to stay away from; two Job # boxes. I have been told there is an existing db I need to look at around here that operates in the fashion sought. If it really is what I am looking for I'll reply...

I opened the attachments attached to your messages sent at 16:00 and 16:48. I clicked on the attachment in Edge which went to my Downloads folder. I then extracted the files into the default folder in Downloads and then opened the accdb. Nothing ground breaking there, nothing out of the norm.

No forms opened automatically. I manually opened frmPackingSlipHeader.

I still cannot see the text box in Design or Form view! I will see if having the searched text box alone in the header will meet expectations.

Regardless of seeing your new text box, are you telling me that the same text box cannot be used to search qryMAIN_Master.JOB and receive the returned JOB field string in the case of an existing, found recordset?

Umm... I do see that the Back Color has been set to black for Form Header but I do not see ANY controls. I dragged and dropped a selection box over the whole area and nothing becomes selected, just in case it was all transparent. I do not see a text box in the Form Header. I've expanded Form...

Umm... theDBguy... I don't see a "new" text box. Did you make changes to an existing one perhaps? Or am I missing something?

Sure theDBguy. My hope is to be able to type in the JOB text box a valid job number (string) and AfterUpdate (ie hitting Enter), qryMAIN_Master is queried and if the string entered in frmPackingSlipHeader.JOB exists in qryMAIN_Master, its recordset would populate the form, if it did not exist...

Here goes. I pretty much took everything out that was not necessary. I did leave some cleaned records in the tables so the queries and forms show data. The AfterUpdate for frmPackingSlipHeader.JOB is the only code. That is new. If you strike that you will see the form can use Access search...

@theDBguy - It would be difficult to minimize. It uses all linked tables to a SQL back-end.

I came across this Access World hit - forums/threads/find-record-in-table-and-populate-fields-on-form.34780 - that is as close as I have come to my issue after searching for about 16 hours! I have a similar issue. I may not even be barking up the right tree. I do want to bring up a queries'...

Look forward to many useful converstaions.