Now what

[rescobar]

I'm trying to build a FAQ database. From a combo list you select a Product then a Model. Then you enter in text fields a Summary, Detail and a Solution. Afterwards you can query this information. Here's the problem. I made a form that has my Cascading Combo list, one for Product and the other for Model. However the form is not linked to a table to record entries. Am I toast, start over or can I move forward? Thanks.

[TG_W]

Why not create a table to record the entries?

[rescobar]

I'm a newbie with Access so everything I'm doing is a learning experence. I made the Cascading combo list from an edited template. So currently I have a form and the combo list is poplulated from a table. I have not figured out how to take the current form and go through the process of making a table to record the entries. If I create a form first then not an issue but I got the cart before the horse right now.

[TG_W]

If you click in the open space in Design View, you can set the 'Record Source' to the table you want to reference in the 'Data' tab in the 'Properties Sheet'. Then, in the 'Unbound' Text Boxes, you can bind the fields of the table (or query, for that matter) by the same method.

[rescobar]

OK I set the record source for all fields to a table I created called records. The issue now is that the form does not have an Advance to new reocord. It's a single static form. If do a new file a test and use the form wizard then those forms always have the abilty to recond an entry and adance to the next one.

[rescobar]

OK I got it working. It was some setting in the Property Sheet that allowed the From to write to the table and navigation so it could advance. Thanks. Trying to mark this as solved but did not located SELECT * FROM Users WHERE Clue > 0

[TG_W]

It's under Thread Tools at the top. Sorry I didn't get a chance to get back to you between your last two posts, but I'm glad you got it resolved. You could also set the form to 'Continuous' to view multiple records in your table at one time.