I have created a form based on a query that is used to enter and update information about a specific groupd of records. The user uses a combox box, also on the form, to enter criteria for the query. Once a value is entered into the combo box I attempt to requery the form but I keep getting an error message about trying to create a record with a duplicate index or it gives me a new record and I am unable to see the rest of the records that should be displayed. The action I am using is FormName.Requery but It doesnt seem to be doing the job and I cant find much informatoin about using requery.
I also have a memo field used for notes about the subject but when I added the memo control to the form I am unable to see the data in the field. If I look in the file it exist but no luck so far gettin it to be displayed on the form. I has also been diffcult finding information about this subject.
I also have a memo field used for notes about the subject but when I added the memo control to the form I am unable to see the data in the field. If I look in the file it exist but no luck so far gettin it to be displayed on the form. I has also been diffcult finding information about this subject.