Updating With a Form

[qurn]

I'm trying to make a form that can be used to update a database, I have a string of several questions, so I thought I'd just start with the easiest ones and work up from there.

First, how do I get it to always open on a new field, and go to a new field after update.

Second, I have two combo boxes one labeled Manufacturer, and one labeled Ride. How do I get it so that after I update the manufacturer combo box that it only shows rides made by that manufacturer.

 

[boblarson]

First, how do I get it to always open on a new field

Set the form's Data Entry property to YES

and go to a new field after update.

If a user clicks the next record button it will do so. You can also put a button on your form for NEW RECORD and have it go there. If you click to add a button, Access will bring up a wizard that will let you choose that action.

Second, I have two combo boxes one labeled Manufacturer, and one labeled Ride. How do I get it so that after I update the manufacturer combo box that it only shows rides made by that manufacturer.

Do a search here on Cascading Combos as that question has been asked hundreds, if not thousands, of times.

 

[qurn]

Thanks Bob, you're the best.

Let me play around with this a little bit then I'll come back and ask my other questions.

 

[qurn]

Ok, Third question.

I have a query called "Bulliten Query" that I am using as a source for my form. The problem is that after I set the Data Entry property to "yes" it's not putting in the values into the query.

 

[boblarson]

Actually, do you mean it's not displaying data? When you use the Data Entry set to YES, it only shows the data that you are entering in that current session. Any data you enter as you go will be displayed but not previous data. If you want all data shown, don't use the Data Entry set to YES but in the On Load event of the form you can put

DoCmd.RunCommand acCmdRecordsGoToNew

if you want to open to a new record.

 

[qurn]

Thanks Bob, but what I mean is that it's not actually putting the data in the tables.

Is there something else I need to do?

 

[boblarson]

Are you sure your query is updateable? Open the query directly and try typing data into it. It will either let you or not, if not it isn't updatable.

 

[qurn]

Let me explain my database. Although there is lots of info. in it there isn't much to the infostructure.

I have 5 Tables:

Bulliten:
ID (auto number)
Bulliten name
Link (is a hyperlink to the actual file; *.pdf, *.tif, etc.)
Date

Ride Name
Ride ID
Ride Name

Manufacturer
Manufacturer ID
Manufacturer

Who Makes
Who Makes ID
Ride ID
Manufacturer ID

BulRidWrd
ID (auto number)
Who Makes ID
Bulliten ID
Keyword (this is for information about the bulliten)

All the relationships are where you'd expect them to be.

I can update it from my main query but I cant imput any info into the keyword field from the query.

 

[qurn]

Are you sure your query is updateable? Open the query directly and try typing data into it. It will either let you or not, if not it isn't updatable.

Yeah I tried updating from the Query and it does work.

 

[boblarson]

Yeah I tried updating from the Query and it does work.

So, if the query itself works, check these properties of the form to make sure they are set correctly:

AllowAdditions YES
AllowEdits YES

 

[qurn]

yeah I checked those, they're both set correctly. I noticed that when I put in information it's filling up the Bulliten table. I checked everthing and made sure that the source fields where set properly, even used the Expresion builder, but it's still only filling up the bulliten table, and not shoing up on the query at all.

 

[boblarson]

want to post the database here and let me look? I don't have 2002 here at work, so I will have to wait until I get home tonight. If you do, make sure to compact first (Tools > Database Utilities > Compact and Repair) and then zip it with WinZip, or something like it. It has to be 393KB or less to post on the forum.

 

[qurn]

I'd love too but I'm dealing with not only the states information, but the information of several private companies. My boss wants to make it public, but my bosses boss doesn't, and I can't say for the other companies.

I can get you screen shots of the relationships and forms, I just can't send out the info. Also, coping it and stripping the information out of it is something I'd rather not do right now.

Let me know if pictures of anything else would help, You've been a big help so far.

 

[boblarson]

Pics aren't really going to help as I am more "hands-on" and if I can actually play with it I can find the problem in about 30 seconds, usually, as compared with a lot more time. I've run out of things to ask at the moment so, if you get the urge to make a copy and delete the data, I'll take a look.

Maybe someone else will see this thread and have some things to suggest.

 

[qurn]

here's some screen shots, It should be easy enought to build really quickly on your own, if you feel so inclined.

 

[qurn]

Thanks for your help so far. Well, I'm still running into a dead end here. So I stripped the database of all inmportaint and volitile information. If you also have any idea on how to make this thing better please let me know.

 

[boblarson]

Your Additions was still set to NO, but it should be YES.

 

[boblarson]

Oh, and just an FYI for you -

Bulletin is spelled B - U - L - L - E - T - I - N

not bulliten.