Re: Combo-Box list unsorting

With the form open in Design view, look at the Properties window. Find the
RecordSource property and select it. That should activate an ellipsis (...)
to the right of the text describing the recordsource. Click on that, and
it'll take you to the query. Change the query, and say Yes when it asks if
you want to save the changes.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Wissam" <Wissam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A868B2A8-D25C-4333-9B62-243586475925@xxxxxxxxxxxxxxxx
Thanks a lot for your help.
Your precious suggestion fixed problem 1.
However, I still have problem 2.
I am still in the process of creating my database. I created a Form and I
added text boxes to the form by selecting a table (say Table1), then
drag-dropping fields from Table1 to the Form. I later decided that I do
not
want one of the fields (say Field2) in Table1 and the Form. I deleted the
text box for Field2 from the form and then deleted the text box from
Table1.
However, in the form Field option, I still see Field2 (ex. the code on the
title of the Field list box for the Form still says something like :
SELECT
Table1.Field1,Table1.Field2,..; despite the fact that Field2 should have
been
deleted from both the form and Table2. With this, whenever I try to open
the
form again, I get a prompt box asking me to "enter parameter value for the
Table1.Field2" . Is there a way for me to fix this. Alternatively, is
there a
way for me to open the form and delete Field2 from the SELECT... code
sentence?
Thanks a lot for your help.

"Douglas J. Steele" wrote:

Create a query that returns the data in the desired order, and use that
query as the RowSource for the combo box rather than just the table.

For the second problem, take a look at the form's RecordSource. If it's a
query, make sure that the query doesn't include the deleted field.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Wissam" <Wissam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AE9C54DC-0CE7-423A-A8F3-A0A800ECD773@xxxxxxxxxxxxxxxx
Hi, I have a combo box on a form with the list rowsrource type from a
table
that contains names of medications. The list on the combo box gets
automatically sorted alphabatically. Is there a way for me to have the
list
in the combobox show the data as I want (based on the medication that
will
be
chosen the most on top of the list of the combobox), rather than
alphabatically?

Another question: On that same form, I added a textbox that had a
control
Source a field I (called visitType) in a table called visits. I do not
want
this field in the database any more. On the form design view, I deleted
the
text box and then deleted the control source field (visitType) from
the
table. However,after I did that, whenever I try to open the form again,
a
prompt box pups up asking me for the parameter visit.visitType value.
On
the
field list for the form, I still see the visitType as an option (though
it
is
not on the form). Is there a way to fix this?

Thanks a lot.





.

Relevant Pages

  • Re: Count combination of fields in one table occurring in another table
    ... >Table1 Example values ... Not sure what you mean by "dynamic query", ... FROM table1 LEFT JOIN table2 ...
    (comp.databases.ms-access)
  • Re: Dont know where to start
    ... Field2, etc., and running your SQL: ... FROM Table1 ... Neil can you explain your SQL to me. ... And this is what i got from query 2 ...
    (comp.databases.ms-access)
  • Re: Left outer join or Subquery
    ... Run SET STATISTCIS IO ON and SET SHOWPLAN_TEXT ON. ... You can compare both queries.Also consider creating Foreign Key ON Field2 in ... Table1 and see if it helps to put an undex on the column. ... > Query 1: ...
    (microsoft.public.sqlserver.programming)
  • How can I make a form re-read (refresh) its datasource
    ... seems to work except when I open the display form to display the data ... the display form with this new query as the recordsource. ... So, when I execute, if the form F2 is not open, the form opens and ...
    (comp.databases.ms-access)
  • Re: Opening a Report from a Filtered Form
    ... Create a query into the main Client table. ... Add the Attorney table to the query. ... Open the report in design view, and set its RecordSource property to this ...
    (microsoft.public.access.reports)