compiler error

[Sheba]

hey June7 sorry for the delay. I had previously passworded the project that is why it wouldn't let me copy and paste the source code in another dbase. Anyway I got around it but had major challenges stripping down the database. I decided to re-recreate the controls that were referenced in the "Method or data member not found" error message. I have represented them in the attachment.



Many thanks for your help.

[June7]

PaediatricForm Current event errors on Me.placedBy. There is no control named placedBy. Same for venousPlaced. Use bang (!) instead of dot to refer to field in the RecordSource.

Me!placedBy
Me!venousPlaced

Then the procedure is missing End If line.

You use .Text property for cmdSRCHBOX. I have never used .Text. Can probably remove it. Value is the default property for data controls.

Suggest you give controls meaningful names.

[Sheba]

Thanks June7.
1) placedBy and venousPlaced are not control names but field names in the Paediatric table...

2) the controls are unbound and only these two field names are giving me problems. I didn't use Bang(!) for the others are they are fine.

3) I remember that after creating the table and linking it to the Front End, I realised two columns were missing - venousPlaced and placedBy. I then went into the database, added the two columns. Went back to my front End, deleted the old link to that table and relinked it. Perhaps that is the reason why it does not see the fields?

[Sheba]

I think I fixed it! I deleted the links to ALL the tables from my FrontEnd, saved and exited. I then duplicated the offending table and renamed it, saved and exited. I then went back to the Front End and relinked to ALL the tables (plus the new, minus the old). Debugging has moved from those lines of code now. So here's hoping...

[June7]

The edits I described worked for me. Forms open without error.

Glad you found a solution.

[Sheba]

hi June, I have about 40 option controls on the form and only these two fields were giving me problems. I used the bang as you suggested but I still got the error message. Anyways ts'all good now. Thanks for your help