Re: Combo-Box list unsorting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: Combo-Box list unsorting
    ... RecordSource property and select it. ... it'll take you to the query. ... drag-dropping fields from Table1 to the Form. ... want one of the fields (say Field2) in Table1 and the Form. ...
    (microsoft.public.access.gettingstarted)
  • Re: Using flexible query criteria
    ... criteria for the query is based on the user's input in the main form. ... One of the user inputs is a field called "Vendor_Name" (in the form of ... and said that Field1 is the primary key and is an autonumber field, and Field2 is the field shown in the combo box, you must modify it to a UNION select, similar to ...
    (comp.databases.ms-access)
  • Re: Group By, Max and Min
    ... SELECT field1, field2, field3, LAST, MIN, MAX ... I have (from a previous saved query) these fields: ...
    (microsoft.public.access.queries)
  • Re: need to delete record having two different fields with same identical value
    ... Assuming you're always comparing the same two fields (Field1 and Field2) ... Run the query to check it, and then turn it into a delete query. ... which might be a lot safer (I hate deleting data unless I ...
    (microsoft.public.access.gettingstarted)
  • Combining multiple tables into one table
    ... There is an access database that has 3 tables. ... field2: Last_Name ... field3: First_Name ... field4: DOB ...
    (comp.databases.ms-access)