Issue when trying to create button to open a form to show specific records

[mkdrep]

I have a main form [Job Quote Form 10-2205] and I am trying to add a command button to open up [Job Process Form-MKD] and have the [Job Process Form-MKD] open up and only show the records that match a certain field, in this case what I call "JobTrackNo" in the [Job Process Form-MKD]. (see attached .jpg)

This problem started to happen only recently, namely you will see that the left column under [Job Quote Form 10-2205] is blank, where normally there had been a number of fields to choose from. The fields are all still available, they are just not opening when I try to match two fields. :banghead:

Thanks in advance for the help.

 

[mh123]

Would you be able to strip any confidential data and upload a copy of the db? I can certainly take a look if still required.

 

[mkdrep]

Would you be able to strip any confidential data and upload a copy of the db? I can certainly take a look if still required.

thank you for your kind offer, however this is a HUGE db and it would take me forever to strip the date down to a point where I could attach the file.