search and retrieve problem

[antonyx]

a form should open when a record in a listbox is double clicked.. the form doesnt open.. and when i open it independantly i am unable to edit any of the fields.

the form is based on a multi table query.

if anyone can suggest why it doesnt work i would be most grateful.

2003 version on my webspace cos it didnt fit by 100k or something..

 

[antonyx]

right let me spend 3 hours trying to fix this..see if i can sort it

 

[Oldsoftboss]

Not knowing what you are trying to achieve here, but see how this goes.

The table structure needs a lot of work, but this may be a start.