OpenArgs Help (with example)

[Maxine1010]

Hi,

A problem has occurred with my database and its driving me insane, please help!
Data is being entered from questionnaires into the database via a number of forms. The system works by the user:-
(1) logging the patient and form details via the form called '020 fm_FormLog_HIPS'
(2) The user then selects the radiobutton to identify the operation and then the patient they want to enter the remaining data for (from a drop-down list on the form '011 fm_DE_OpType');
(3) This opens the form '101 fm_DataEntry_PRE:HIPS', creating a new record if one does not exist and the user data-enters the outstanding information.

The problem that is occuring is that when the sex and date of birth of the patient is selected/ entered on the latter form an error message (Error 3022)appears saying duplicate values occur but I don't know why.

I have attached an example database (2003), this is a stripped down version as normally the user has the option of 4 operation types thus the use of radiobuttons on the form '011 fm_DE_OpType', but I didn't think it was necessary to include everything here.

Thank you in advance for any help you can provide!

 

[Guus2005]

There are a lot of things wrong with your database. For starters it is not normalised and you're using a lot of tables with two fields, an ID and a VALUE. They are called reference tables and can be stored into a single table since you will only store the unique ID.
Your comboboxes are showing the number instead of the text. Use ColumnWidth=0cm;3cm which suppresses the first column and returns the first column when it is bound to the first column.

Your error message occures because the form is bound to a query. Usually the resulting recordset is not updateable which does not seem to be the case here. You are trying to update an autonumber field: the query bound form contains [101 Quest_Data_PRE:HIPS].* . The asterisk also contains the autonumber field. I think you need to list every field explicitly, leaving out the autonumber field hSerialID


HTH