RE: Combo box formatting issues

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

To start with, it is better to use bound forms. Using Unbound form's causes
you to loose a lot of the power of Access. It also is more work because you
have to code everything yourself.
I would recommend you take this approach:
If all tabs on the form are using data from the same table or query, then
use the query or table (I suggest a query even if it is just one table) as
the Form's Record Source. Then bind each field you want to use to a control.
You can put the controls on the pages you want to to group them all together.

If each tab is a different table or query, then put a subform control on
each tab and make the Record Source of the form being used as a subform the
query for the data on that tab.

Now the only thing to do is the navigation. That is, the technique on the
first tab to navigate to the other tabs.

Before we get to that, post back with some info on your data. Is it all in
one table or is it a separate table or query for each form. I will help walk
you through it. What you are doing is fairly advanced.
--
Dave Hargis, Microsoft Access MVP


"Mithrial via AccessMonster.com" wrote:

I don't believe my problem to be a difficult one however I've not worked in
Access for several years and I've forgotten a lot of what I learned. What I'm
attempting to do is this.I've created a tabular form. The first page or tab
if you will ask the user to select from one of four drop down lists. Based on
the what item is selected from these lists... i.e., Project Managers, the
selection would port the user over to another page where the created fields
(Open projects, date, status and priority) are autopopulated. A friend of
mine in the office used a linked form with this code and he was able to
autopopulate his form. He gave it to me to use to do somethin similar. If
there is another or more streamline way of doing this any help you provide
would be greatly appreciated. Again, my knowledge of Access is limited so I
appreciate your patience in advance. (In answer to one of your questions, yes
this is an unbound form... I wasn't sure how else to do this) How do I check
to see what the "Column Count Property" is?

Klatuu wrote:
Is there some reason you are doing this this way?
Is this an unbound form?
Can you describe what it is you want to do, please.

Check to see what the Column Count property is. It should be the same as
the number of fields in the combo's row source, which is the only limit I am
aware of.
I'm using VB to attempt to autopopulate a tabular form I created to maintain
track of my company's open projects. A friend of mine provided the code that
[quoted text clipped - 23 lines]
Am I missing syntax that causes this or is there a limitation with this
command?

--
"To Craasssh is human... to connect, divine"

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200709/1


.

Relevant Pages

  • move from one field to the next
    ... I have a form that pops up when I run a report. ... It contains four unbound ... No need to press enter or tab. ... I have anoter form which is bound to a query. ...
    (microsoft.public.access.forms)
  • Re: Append Query Date Criteria Problem.
    ... it will be best to get it working in the query. ... INSERT INTO tblSSAttendance (SSClassID, SSClassDate, SSMemberID, ... Form Data Tab: ... Private Sub btnAddNewRecords_Click ...
    (microsoft.public.access.queries)
  • Re: error opening form "cannot open anymore databases"
    ... I have only 1 small hidden form which is unbound on the ... >have a tab control, anything that is not on the current ... >by clearing the SourceObject or RowSource (depending on ... >subform controls on each of the tab pages except the ...
    (microsoft.public.access.forms)
  • Re: Same date range in main and sub form
    ... the name of the query on which the sub form is based. ... If you use the parameters StartDate and EndDate in the query, ... You could put them as unbound text boxes on the main form, ...
    (microsoft.public.access.forms)
  • RE: Error in 2007 but not in 2003 - suggestions please
    ... i had the same problem when i upgraded from 2003 to 2007 using SQL Server ... not found in this query) i had to create and save the forms query in the ... each tab has independent subforms and query ... following error message: ...
    (microsoft.public.access.queries)