Re: Form problem

> Hi All
> Sorry about the weak subject, but I don't know what to call it.
> The problem:
> I have a table of DVDs and a table of genres.  One of the items in the DVD
> table is genre.  The table of genres has an ID, genre ( MYST, HIS, ACT,
> SIFI, ...), and a name ( Mystery, Historical,  Action, Science Fiction, ...)
> .
> I have a form called Input that I use to enter new DVDs. I can also use this
> form to view DVDs. It has a Genre input box. What I would like to do is:
> If the current 'genre' "IS EMPTY" THEN display the list genres from the
> genre table, showing the full name and when selected enter the genre in the
> DVD genre table.  ELSE show the current entry. OK this is somewhat
> confusing.
> If  DVD_genre is not empty show that. IF it is empty the show a selection
> list from the GenreTable. Show the full name and insert the abbreviation in
> the DVD_Table.
>
> I thought I use BASIC but all I see in the form editor is SQL and some
> others I don't think will work ( I could be wrong).
> Any thought and or suggestions would be appreciated. Thanks
> Cliff
>
> --
> mailto: c.liles@...
> Clifton R. Liles    "Software to the Stars"    lilescr@...
> Pearland, TX 77581   c.r.liles@...  c.liles@...
> - Speaking for myself!  Standard disclaimer applies. -
> This address may *not* be used for unsolicited mailings.
> Failure is not an option. It comes bundled with your Microsoft products.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>
>