Access, and parameter values on a form.

[BarryM]

Hi folks wondering if anyone can help here.

ive created a database (well butchered and plagarised a database) so i can input customers details, select the appropriate catergory (wedding, portrait), and the selected products for each category ( package 1.2 and 3), it was all from a previous database sample called Northwinds that im sure anyone doing anything with access has heard about.

Im all there with it but on one of my forms, rather than it just opening straight to the form to input orders, its opening a parameter value box, 3 times, wanting 3 bits of info, i can click through these putting nothing in them to eventually get to my form to input data, so i dont think they are doing anything. My query is, can i get rid of these value parameter boxes, on the form design i cannot see any where that links these boxes, so have no idea, ive also had a look through module scripts to see if there is any vb code that causes them to come up but im afraid i have no darn knowledge in this, so its been trial and error.

Soes anyone have any idea how to remove those input value parameter boxes from the form design, i would be most gratefull.

Many thanks.


ps. If that dont make sense, il translate it back from Mandarin to English :grin:

[StuG]

Is your form based on a query Barry? or are the fields on the form bound to a table or query ?

If so I think it may be that the form can't find the record to bind the fields to.

I've done a little bit with vb/access if you're really stuck send me your db and i'll take a look for you.

[BarryM]

thanks pal,

err im not sure, basically that particular form is a delivery form, but before it kicks in its looking for a set of values, i.e shipping date etc etc, i can input nothing in them and click through and form still opens no problem, ive looked on the form design but see nothing hard coded into it for those parameters.


Il send the db over by email pal, thanks sooo much.

[JBMUK]

sounds like there is either some vb or its a parameter value - first place I would start is look if its using a query, then figure out if its calling from vb or via some parameters..

there is quite a bit of vb in the northwind as well as querys..

Hopefully Stug can sort it for you