Search Combo Box on Form

[Rhubie]

Seach Combo Box CompanyType


I need to have the list that appears be just the distinct types

Advertising
Web
Shipping
Shipping
Other
Advertising
Web

I want the list to be distinct rather than all records to do the search from - it should be as follows:
Advertising
Shipping
Other
Web

The combo box data is a field on form also

[pbaldy]

Typically those would come from a table of company types. If you're trying to get it from a transaction table:

SELECT DISTINCT CompanyType FROM TableName

[Rhubie]

It is in a combo box that I am using to search for a specific CompanyType - I used the wizard to create the search. Now I am also having a problem with the form because I am using it for data entry and for searching. If I turn the dataentry to yes - then the search does not work - I am not sure how to have both things work in the same form.
I tried putting Me.DataEntry = False in the on-click of a button but I get a compile error - I am getting confused

[Missinglinq]

Why are you setting Data Entry to 'Yes?' This setting only allows the entering of New Records, not the viewing of existing Records

No Viewing = No Searching

BTW, setting Data Entry to 'Yes,' despite its name, is not needed to enter Data! With Data Entry set to 'No,' AllowEdits = Yes/True and AllowAdditions = Yes/True, you can add new Records, edit Records and search Records.

Linq ;0)>

[Rhubie]

I have it set to no - I would like the form to open with a new record
I am getting this error with my search box also

[pbaldy]

The error would imply you have code somewhere it shouldn't be. In the VBA editor, hit Debug/Compile and fix any problems it shows.

[Rhubie]

I did find the end sub that was there - but I still have the problem of opening the form in a New Record and still be able to use the search box or scroll through the data.

[pbaldy]

Look at GoToRecord in VBA help.

[Rhubie]

I'm not very good at VBA - where would I find the help

[Missinglinq]

Private Sub Form_Load()
  DoCmd.GoToRecord , , acNewRec
End Sub

Linq ;0)>

[Rhubie]

Where do I put this code? I'm sorry I am really new to the coding

[Rhubie]

I got it - thank you very much So easy yet so frustrating. The only problem I have is that it goes to my combo search box when the form is opened - can I direct it to another field?

If I am in Access and want to look up VBA code help - where would I find it?

[Rhubie]

Got it - is there a good reference for VBA Code? I used: DoCmd.GoToControl "ContactLastName"

If I am in Access and want to look up VBA code help - where would I find it?

[Missinglinq]

…If I am in Access and want to look up VBA code help - where would I find it...

While in the Code Module of any Form, place term(s) in the search box at the top, right of the window. If a list of pertinent help topics pops up, choose the one that seems the most appropriate.

For a specific command, property, etc, place the cursor in the middle of said command or property and hit <F1>. If more than one topics pops up, once again, try the most pertinent.

Here's some sites, listed from the easiest to understand to the more difficult, that go into the nuts and bolts of development, after you get a handle of table design.

Chrystal has an excellent “basics” tutorial:

http://www.accessmvp.com/strive4peace

This is a little more advanced, but still a great starting point, having 28 well written, well defined, clearly named chapters.
:
http://www.functionx.com/vbaccess/index.htm

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

MVP Allen Browne's extensive list of tutorials and on-line reference materials:
http://allenbrowne.com/links.html#Tutorials


Linq ;0)>

[Rhubie]

Thank you very much for your help