Search results

Hi David, I think I am with you now. I will give it a try. Thank you for your help. Regards, Peter:)

Hi David, Thank you for your very fast reply. I am afraid I am rather a rooky in the coding world so I am struggling with your reply. I understand 'DoCmd' but I haven't a clue what you mean by 'Copy the relevant fields to mem variables' and 'Paste the relevant mem variables to the controls'. Can...

I have designed a form that records pre-treatment activity for hospital patients. In some cases, a patient may require treatment on two different areas of their body but these would need to be added as separate records. Most of the fields in the two records would have the same value however so...

Hi RG, I have done a little event coding. The original form has the Record Source set to the PatientDetails table. Would this make the necessary code something like Me.RecordSource = !Table!PatientDetails ? I'm using Access 2003 by the way.

Hi Makaveli, I have previously tried messing around with the 'open acnew' approach without success. I think I might nearly be there with RuralGuy's idea.

Hi RG, Thanks for the prompt reply. I see where you are coming from but could you give me more detail on what the OnEnter event needs to do in the ComboBox? An example bit of code would make it clear to my tiny brain!

I have designed a form to display patient treatment records. The main form has various fields which are not enabled to prevent data editing. An unbound combo box is used to select a patient to display. Both the main form and the sub form have the 'Data Entry' property set to 'No'.The main form...

Thanks for that Pat. Easy when you know how isn't it? Sorry for delay in replying - life has been rather hectic!

I have developed a database which uses a form with a combo box (unbound) to select PatientHospitalNo (Primary Key) from the PatientDetailsTable and display patient information in this form and patient treatment episodes in a sub form. The customer has decided that they would prefer to select a...