PDA

View Full Version : To find value of asked for parameter



mud2
05-05-2009, 12:13 PM
In a form with a subform, each with its own underlying table. Each table has a field called "name", which is the "link".
The form has a navigation button for Adding a new record. But when checked, a box pops up asking for the new value (parametera). FINE! How do I access(?) this new value after it is typed in?
Access has "numerous" ways of finding parameters, but all seem to apply towards finding the name of a Southy African Tobacco grower with red hair who only farms on alternate sundays, and then only when accompanied by his mother.
All I want is to get the value I type in when asked.
I've tried getting to an inputbox...doesn't work!

OBP
05-06-2009, 02:41 AM
Mud, that pop up parameter sounds like something is missing from your table that is on the Form and Access is asking you to supply it.
When you use a new record Command Button it should just provide a New Blank Record.
You can use
DoCmd.GoToRecord , , acNewRec
to go to a newrecord and it should not give any parameter message.