Search results

anyone could help pls? appreciate!!!

sorry i didnt make it clear...when i put the 2nd subform on the 1st. It worked properly. It however displays messy records thats why i put both subforms on the mainform and thats where the problem arises. Have no idea why it cant work when both on the mainform...If my link syntax is wrong then...

i have a mainform containing 2 subforms. 1st subform will display a list of records for a search on the mainform.2nd will display a list of records for a selected record on the 1st subform. The problem is that 2nd subform will show only records corresponding to the 1st record on the 1st subform...

First thanks a lot for a very quick reply...I have seen your other posts and all are very helpful. The bookmark u sent, i have seen but i dont completely understand..:o Anyway, i tried the systax but still didnt work.I substitute "SubFormControlName" with "MasterPno-Link" where it will show a...

hi all, got a tricky problem...hope to get help from u all...appreciate!!! i almost complete this but run into a "refresh" problem..I have a mainform with a textfield where users can input a number to search for an item; if found, a list in the 1st subform will appear in datasheet view. When i...

thanks a lot Oldsoftboss for your reply! I have found a way to work around that w/o having to add any Primary key(i thought i wouldnt work personally but i may be wrong)Anyway, in the subform, i still use the same query accept that i set the criteria for that particular item i want, so it just...

i understand a bit on relationsip and stuff but this is different case here as i'm creating an additional feature based on already-built tables. As mentioned, tblStockItems and tblUsedIn are only related by a field Assy with Yes?No data type( value 0 or -1). And there is no relationship at all...

hi all, I can't seem to find any topics related to my prob, be it here or Google :( so here i am asking you all for help! I have a main form built on a table named "tblStockItems" and a subform built on a query named "qry" which is based on tblUsedIn. The main form shows each item in...