Question adding feilds (1 Viewer)

[mrcunknown]

Hi all,


I have found a searchform on internet what i want to use. I'f added 2 more lines in the table (DOCLink and DOCDescription). If i go to frmDOCTitles i dont know how to put the extra lines from the tbl in.

DOCLink must be a clickable link to the location on de computer/networkfolder


who can help me with this?

 

[arnelgp]

you need to add an OR condition to your query

 

[Pat Hartman]

If you added the items while frmDocTitles was open, you won't be able to bring them up because of the method you are using (bad design). Close frmDocTitles and reopen it and the search will work correctly.

A better method would be to use the where argument of the OpenForm metod rather than the recordset.clone. Then you would not have to close the form before trying to search for the new records. The reason your current method doesn't work is because when you open a form, the recordset is read into memory. If you then add new records to the underlying table, that doesn't alter the recordset in memory.