Hi, i have a search button on my form, whenever i search for a record a non
existant record it opens a blank form, and when i try to search for another
record it gives me a runtime error '3314'.
also i have created a 'Next record' button, and when i navigate to the last
record to a blank record, i cant seem to go back to previous record or search
for any other record and gives me the message 'you cant go to specified
record'. I know its something to do with one of my primary key as its
'required', but when i set the required to 'no', and everytime i search or
navigate to a blank record it will save the blank record into the table.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12747-searching-through-forms.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12747
Can anyone help me with this please? your help would be much appreciated.
please let me know if you need any other further detail.
thanks