Disappearing controls on form

mad4co · Guest

I'm still trying to get the hang of this, so please bear with me. Why do all controls except my key field disappear when I save a form then reopen it? They stll seem to be there, as clicking on the form in design view shows the green corner handles, but I can't see them or print them.

Also, can anyone point me to a "how to" (or better still, an example database) for Using OOo data source to set up a relational database with primary keys, with a subform, and the main form record selected via a combo box? I can't get the macro to link named parameters (in the how_to_link_tables_using_named_parameters.sxw documentation) to run without errors, or be able to set a primary key (greyed out when I copy the table).

Any help would be greatly appreciated.

Howard Oates

avantman42 · Posted: Mon Jan 12, 2004 1:34 am Post subject: Re: Disappearing controls on form

mad4co · Guest

Thanks very much for the links - that will get me going when I've downloaded the extra bits I need. I still can't find a way around the disappearing form controls - I get the same behaviour on both Win 98SE and WinXP machines. Is it just an option I've missed? If I can work out how to do it, I could show a couple of screen shots.

avantman42 · Posted: Tue Jan 20, 2004 4:17 am Post subject:

I really don't know what is happening with the disappearing controls. This page will tell you how to take a screen shot:
http://graphicssoft.about.com/cs/general/ht/winscreenshot.htm

To show the screen shot on this forum, it has to be hosted on a web server, then you can either post a link to the file, or use something similar to the following BBCode:
[img]http://www.phpbb.com/images/phplogo.gif[/img]
(see http://www.oooforum.org/forum/faq.php?mode=bbcode#9 for more information)

Russ

ibarton · Guest

I had a similar problem to what you are describing so instead of giving the value to the form control I had to assign it to the form row. The code I used was:

'get a Form object
Form = getForm("Invoice")

'set my invoice (first field in table) to next available
Form.updateInt(1,getNextInvoice())

'set my description (fourth field in table) to default
Form.updateString(4,"default description")

I am not sure if this will fix your problem (as my issue was slightly different). Good luck,

veru · Power User Joined: 09 Jul 2004 Posts: 80

Hi,

I am struggling with the same problem. Did you find a solution?

Verena