Selecting a record from a form

  • Thread starter Thread starter David Coates
  • Start date Start date
D

David Coates

Help! I have a form which has a combobox only on it. The data for the
combobox comes from a table made from a query. The idea is that I can
select a record in the combobox and use that in another query to restrict
the records I get for a report. I have noticed that after highlighting the
record in the combobox, and the form is closed down, the table has had that
highlighted record added to it as a new record.

I have tried setting 'Allow additions' and 'Allow Edits' to 'No'. When the
'Allow Additions' property is set to 'No' the combobox just disappears, when
I set the 'Allow Edits' to 'No' the form will not allow a record to be
selected. I have also tried setting the combobox data properties 'Locked'
to "Yes' but this also stops me from selecting a record.

There must be a way to select a record for use as the criteria in a query
without having that record appended to the original data. I use VBA to
return the results of the form selection as the query criteria, but have
noticed the phenomenon even just using the form and selecting a record
without running a query.

Any suggestions most welcome.

--
Regards,

David Coates

Progen Ltd.
Mobile : 021 685 607
Phone : +64 7 839 3326
Fax : +64 7 839 3327

CONFIDENTIALITY : This e-mail and any attachments are confidential and
may be privileged. If you are not a named recipient, please notify the
sender immediately and do not disclose the contents to another person, use
it for any purpose or store or copy the information in any medium.
 
The problem here is that you have the form set to a data table, and you
don't need this.

In other words, your nice little prompt form is bound to a table, and it
does not have to be. So, open up the form in design mode,and remove the
table that the form is bound to. this will NOT effect the combo box.

I use lots of un-bound forms for reprots. Here is some screen shots to give
you some ideas:

http://www.attcanada.net/~kallal.msn/ridesrpt/ridesrpt.html
 
Thank you to all who sent in their ideas. I am sitting here very red-faced
and embarrassed.

I found the solution. I did have the form bound to the table. No idea why
I did that it so fundamental.

Sorry for using your valuable time on such a silly and trivial matter.

Regards

David C
 
Back
Top