Re: New Records
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
"awach" <awach@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:13D45169-68C5-4FD9-886A-7344DEB8710C@xxxxxxxxxxxxxxxx
I don't think that my form is bound to any queries. I made a combo box with
values that I entered (the advice you gave from the last post). I have the
corresponding text boxes (reference number and description) and one other
text box for the client name. All of these fields are unbound. Is there
something else I should try?
Well, if your controls are unbound then they don't save data (that is what
unbound means).
Does your form have a RecordSource at all? If not then it is not bound either.
For the data on a form to be saved the form must be bound to a table or editable
query and your controls must be bound to the fields in that Table or query.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
Relevant Pages
- RE: Filling in form with recordset HELP
... Fields are bound to controls on a form, but not to the database itself. ... then bind fields from the Row Source (a table or query) to controls on the ... The example I posted is for use with an unbound form. ...
(microsoft.public.access.formscoding) - RE: query not filtering according to form filter
... The form that the control is on is UNBOUND. ... controls to make selections that a query uses to filter. ... All of the controls on the form are located in the detail section. ...
(microsoft.public.access.queries) - Re: combobox in query
... And since you are in the form already, you could add two more controls to get the start and end date. ... You can reference the parameters of a query on a report as if they wer fields. ... So if your parameter is, you can reference that in a control on the report. ... Access MVP 2002-2005, 2007-2008 ...
(microsoft.public.access.queries) - Re: bypassing some of the parameters in a parameter query
... the query would not reference ... > the controls on your form directly, but would get the values from ... > These can be coded in dynamic SQL to filter to a set of values. ...
(microsoft.public.access.queries) - Re: Running Query blanks out field in table...
... >combo boxes unbound has caused another issue: when I run the query, ... You need TWO SEPARATE CONTROLS for each field - one (a combo box, ... builtin Query By Form feature to use the same form and controls for ...
(microsoft.public.access.queries) |
|
